Using xlswrite with cell array, how to keep column of numerals as strings?
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Darren Woods
am 18 Okt. 2023
Beantwortet: Dyuman Joshi
am 18 Okt. 2023
I have a cell array that has various columns, some columns contain numbers, some are strings. One of the string columns contains some entries that are all numerals. When this gets saved using xlswrite, the numeral strings become numbers. One negative side effect is that any numeral string that starts with a '0' will drop this. Example:
my_cell_array = {'field1', 'field2', 'field3'; 12345, 'abcdef', '1a2b3c'; 54321, 'fedcba', '01234'}
Here the string '01234' will get saved in Excel as the number 1234 which I don't want as this entire column should remain as strings.
How can I get around this problem?
Thanks, Darren.
0 Kommentare
Akzeptierte Antwort
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!