Saving strings (ex. 0222222) from MATLAB to Excel using xlswrite is saving as a numeric.

1 次查看（过去 30 天）
Dankur Mcgoo
Dankur Mcgoo 2018-3-12
回答： Fangjun Jiang 2018-3-12
Hello,
I am trying to save a string (i.e. 02222222) into excel. I need to keep the leading zero, but when I use xlswrite in MATLAB is converts it to a number, so I lose the leading 0.
I currently have my data saved in a cell array as a string.
Any clue if this is possible?

请先登录，再回答此问题。

回答（1 个）

Fangjun Jiang
Fangjun Jiang 2018-3-12
Add a single quote in front to deal with Excel
a={'"022','''022','022'}
xlswrite('test.xls',a);
winopen test.xls

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by