Importing data from excel
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
0 Commenti
Risposta accettata
Oleg Komarov
il 10 Ago 2012
Modificato: Oleg Komarov
il 10 Ago 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.
0 Commenti
Più risposte (1)
Walter Roberson
il 10 Ago 2012
Modificato: Walter Roberson
il 10 Ago 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.
0 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!