how to read xls file with char value?

21 次查看（过去 30 天）

显示更早的评论

fred bnm 2016-10-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/309530-how-to-read-xls-file-with-char-value

评论： Walter Roberson 2016-10-27

采纳的回答： Star Strider

after using xlsread function,Only numerical output variable but Character variable can not be read pleas guide me.

采纳的回答

Star Strider 2016-10-27

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/309530-how-to-read-xls-file-with-char-value#answer_241044

在 MATLAB Online 中打开

Use xlsread with at least two outputs:

[num,str] = xlsread(filename);

I have found that pretty much every time that I need strings from a .xls or .xlsx file, that I need to use the third output from xlsread, the "raw" output. -- otherwise it gets too messy to try to figure out which numbers correspond to which strings, in my experience.

请先登录，再进行评论。