how to read the ms excel numeric data?

Question

bsd 2012-4-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/34341-how-to-read-the-ms-excel-numeric-data

Hai,

I am using ms excel 2007. I have a excel file 'ac.xlsx' consisting of numeric data of 16 rows and 179 columns. I tried reading this excel file using the xlsread() command as (z=xlsread('E:\ac.xlsx')), in command window. But after the above command was executed z was an empty matrix. Why is it an empty matrix? Looking forward for your reply.

BSD

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2012-4-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/34341-how-to-read-the-ms-excel-numeric-data#answer_43051

在 MATLAB Online 中打开

try use

z = xlsread('E:\ac.xls'))

3 个评论
显示 1更早的评论隐藏 1更早的评论

bsd 2012-4-3

I created a matrix of real numbers and used the xlsread() command, it worked. But when I created a matrix of complex numbers and used the xlsread() command, it is showing empty matrix. I need to read a matrix of complex numbers for my application. How could I do this? Looking for your reply.

BSD

Andrei Bobrov 2012-4-3

your file 'ac' save as '.xls'

请先登录，再进行评论。

Answer 2

som 2012-4-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/34341-how-to-read-the-ms-excel-numeric-data#answer_43058

在 MATLAB Online 中打开

 You can use following command:
   xlsread('aaa.xls', 't1','A1:FW10')

aaa= name of excel file; t1= name of sheets having your data; 'A1:FW10'= cells containing your data

2 个评论
显示无隐藏无

bsd 2012-4-3

I am using ms excel 2007 version. So ".xls" is not working. That is why I used ".xlsx" and finally there was an empty matrix. I also tried specifying the sheet name and the cell numbers. It is not working, it is still an empty matrix.

BSD

bsd 2012-4-3

I created a matrix of real numbers and used the xlsread() command, it worked. But when I created a matrix of complex numbers and used the xlsread() command, it is showing empty matrix. I need to read a matrix of complex numbers for my application. How could I do this? Looking for your reply.

BSD

请先登录，再进行评论。