writing 1*5 char in one cell in excel
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
alex
le 18 Nov 2011
Commenté : Itamar Calderón Osuna
le 24 Mar 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 commentaires
Réponse acceptée
Fangjun Jiang
le 19 Nov 2011
xlswrite('test.xls',cellstr(patients))
2 commentaires
Itamar Calderón Osuna
le 24 Mar 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!
Plus de réponses (1)
John
le 19 Nov 2011
Perhaps the following would work:
xlswrite('test.xls', cellstr(x))
Where "x" is a character array
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!