Importing data from excel

6 Ansichten (letzte 30 Tage)
William
William am 10 Aug. 2012
Greetings,
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 =
'PK'
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
Thanks

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Oleg Komarov
Oleg Komarov am 10 Aug. 2012
Bearbeitet: Oleg Komarov am 10 Aug. 2012
It seems that R2007b wasn't still able to import .xlsx files.
I found the first reference to this type only from R2009a!
http://www.mathworks.co.uk/help/releases/R2009a/techdoc/index.html?/help/releases/R2009a/techdoc/ref/xlsread.html
The workaround
Save it as .xls with excel.

Weitere Antworten (1)

Walter Roberson
Walter Roberson am 10 Aug. 2012
Bearbeitet: Walter Roberson am 10 Aug. 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.

Kategorien

Mehr zu Spreadsheets finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by