Import excel file!
1 view (last 30 days)
Show older comments
So I have to import data from a excel file (xx.csv), it has data types as character and Ascii-real. I used num=xlsread(filename), this opens the columns with numbers . How do I open columns with data type as character??
0 Comments
Answers (1)
Star Strider
on 2 Jun 2016
To retrieve the string or non-numeric data, use two outputs from xlsread:
[num, str] = xlsread(filename);
The ‘num’ variable will have the numeric values, and the ‘str’ variable will have the non-numeric (character) values as a cell array.
0 Comments
See Also
Categories
Find more on Data Import from MATLAB 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!