Writing few lines to Excel cell
조회 수: 5 (최근 30일)
이전 댓글 표시
Hello, I am using XLSWRITE in order to write to Excel file and it works well. My problem is that I would like to write to a single cell a few lines. For instance I would like to write :
'0-12,10
50-60,9
70-76,2'
all in one cell. Currently I only to do it in one row : ''0-12,10,50-60,9,70-76,2' Do you have any idea how to force Alt-Enter?
Best, Tamir
댓글 수: 0
채택된 답변
Image Analyst
2014년 6월 1일
% Create a cell with one multi-line string in it.
oneCell = {sprintf('0-12,10\n,50-60,9\n70-76,2')}
% Write out to Excel
xlswrite(filename, oneCell, 'A1');
댓글 수: 3
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!