How can I use xlswrite to specifically write to a cell as text?
6 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
Brian B
2014 年 6 月 13 日
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 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!