importing an excel table with words
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
AA
am 9 Okt. 2015
Bearbeitet: Nobel Mondal
am 9 Okt. 2015
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 Kommentare
Akzeptierte Antwort
Nobel Mondal
am 9 Okt. 2015
Bearbeitet: Nobel Mondal
am 9 Okt. 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!