writing 1*5 char in one cell in excel
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
alex
am 18 Nov. 2011
Kommentiert: Itamar Calderón Osuna
am 24 Mär. 2019
i have a problem- i have parameter in matlab called patients = 82x5 type char when each row is like 234t1(has both numbers and a letter)
i want to import it to excel so that each patient name will be in one cell and not 5..( a1 = 234t1, a2 = 234t2,...)
how can i do that?
0 Kommentare
Akzeptierte Antwort
Fangjun Jiang
am 19 Nov. 2011
xlswrite('test.xls',cellstr(patients))
2 Kommentare
Itamar Calderón Osuna
am 24 Mär. 2019
Great help! Thank you!
I was sending a date to Excel and, instead of writing the full date in a single Excel cell, it wrote each character in a separate cell. After using cellstr() the problem was solved!
Weitere Antworten (1)
John
am 19 Nov. 2011
Perhaps the following would work:
xlswrite('test.xls', cellstr(x))
Where "x" is a character array
0 Kommentare
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!