how to read xls file with char value?
21 views (last 30 days)
Show older comments
fred bnm
on 27 Oct 2016
Commented: Walter Roberson
on 27 Oct 2016
after using xlsread function,Only numerical output variable but Character variable can not be read pleas guide me.
0 Comments
Accepted Answer
Star Strider
on 27 Oct 2016
Use xlsread with at least two outputs:
[num,str] = xlsread(filename);
1 Comment
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.
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!