How can I use xlswrite to specifically write to a cell as text?
13 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Chris
am 13 Jun. 2014
Kommentiert: Nikolaus Koopmann
am 7 Okt. 2019
I'm trying to write the string '0E0' to an Excel spreadsheet using xlswrite. However, Excel interprets this as a number in scientific notation. The cell appears as the number 0 in the output spreadsheet, instead of as the text "0E0". There appears to be no way to recover the original text information once in Excel (changing number format to text leaves "0" as a string). I'd like it to remain a string through the xlswrite process, otherwise the information is lost. Is there a way to do this?
0 Kommentare
Akzeptierte Antwort
Brian B
am 13 Jun. 2014
I don't have MATLAB in front if me to test it, but you could try adding a single quote before the string, as in
xlswrite('a.xlsx', {'''0E0'})
This tells Excel to interpret the value as a string.
3 Kommentare
Weitere Antworten (0)
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!