Importing data from excel

Question

William 2012-8-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/45768-importing-data-from-excel

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Oleg Komarov 2012-8-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/45768-importing-data-from-excel#answer_55963

编辑：Oleg Komarov 2012-8-10

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Walter Roberson 2012-8-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/45768-importing-data-from-excel#answer_55964

编辑：Walter Roberson 2012-8-10

.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.