Effacer les filtres
Effacer les filtres

Importing data from excel

4 vues (au cours des 30 derniers jours)
William le 10 Août 2012
I have been following instructions while trying to import text data in the form of hex values into matlab. I have one column of data 192 rows deep and I have been using
alpha12_data = importdata('alpha12_data.xlsx')
alpha12_data =
alpha12_data = xlsread('alpha12_data.xlsx', 'A1:A192')
alpha12_data =
neither of these two commands work. Can anyone help me by explaining why? The file alpha12_data is in current directory

Réponse acceptée

Oleg Komarov
Oleg Komarov le 10 Août 2012
Modifié(e) : Oleg Komarov le 10 Août 2012
It seems that R2007b wasn't still able to import .xlsx files.
I found the first reference to this type only from R2009a!
The workaround
Save it as .xls with excel.

Plus de réponses (1)

Walter Roberson
Walter Roberson le 10 Août 2012
Modifié(e) : Walter Roberson le 10 Août 2012
.xslx files were not supported on non-Windows systems (or Windows systems that did not have Excel installed) until R2011b or so. I do not recall at the moment when support for .xlsx files was first introduced -- it is going to depend in part on your Excel version.

Community Treasure Hunt

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

Start Hunting!

Translated by