importing an excel table with words
4 views (last 30 days)
Show older comments
I got an excel table with text and numbers. The code below does not allow me to display the text properly in the matlab table. how can i import the file as cell array so words can be read as well?
fileToRead = fullfile('C:\Users\Untitled Spreadsheet.xlsx');
circa1 = xlsread(fileToRead);
0 Comments
Accepted Answer
Nobel Mondal
on 9 Oct 2015
Edited: Nobel Mondal
on 9 Oct 2015
'xlsread' returns 3 outputs -
[numOnly, textOnly, rawDataInCellArray] = xlsread(xlFile);
If you need the data in only cell array format, use the below style :
[~, ~, mydata] = xlsread(xlfile);
Please try 'help xlsread' to get more info.
0 Comments
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!