how to read xls file with char value?

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

 Accepted Answer

Use xlsread with at least two outputs:
[num,str] = xlsread(filename);

1 Comment

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.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!