how to read xls file with char value?

21 views (last 30 days)
after using xlsread function,Only numerical output variable but Character variable can not be read pleas guide me.

Accepted Answer

Star Strider
Star Strider on 27 Oct 2016
Use xlsread with at least two outputs:
[num,str] = xlsread(filename);
  1 Comment
Walter Roberson
Walter Roberson on 27 Oct 2016
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!