Using xlswrite with cell array containing strings and numbers
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi all,
How could I use xlswrite to write my (n x 3) cell array into an excel spreadsheet? Xlswrite is only compatible with arrays, and at face value converting cells to arrays doesn't seem to difficult. However, my major problem is that my string values have different lengths, which will create a dimensional error if I try to move all of data into one large array.
My data looks something like this:
[5] ['fadfafdas'] ['safdafas']
[24] ['dfd'] ['dds'] ...
Where string-cells in the same row are of equal lengths. Any ideas of how I can write this data into an excel file?
Thanks!
0 Kommentare
Antworten (2)
Andrei Bobrov
am 8 Okt. 2012
A = {[5] ['fadfafdas'] ['safdafas']
[24] ['dfd'] ['dds']}
xlswrite('yourxlsfile.xlsx',A)
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!