Effacer les filtres
Effacer les filtres

importing an excel table with words

3 vues (au cours des 30 derniers jours)
AA
AA le 9 Oct 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);

Réponse acceptée

Nobel Mondal
Nobel Mondal le 9 Oct 2015
Modifié(e) : Nobel Mondal le 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.

Plus de réponses (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by