Writing few lines to Excel cell
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Tamir
am 1 Jun. 2014
Kommentiert: Image Analyst
am 2 Jun. 2014
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 Kommentare
Akzeptierte Antwort
Image Analyst
am 1 Jun. 2014
% 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!