how to read the ms excel numeric data?

3 次查看（过去 30 天）
bsd
bsd 2012-4-3
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

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

回答（2 个）

Andrei Bobrov
Andrei Bobrov 2012-4-3
try use
z = xlsread('E:\ac.xls'))
  3 个评论
显示 1更早的评论
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

请先登录，再进行评论。

som
som 2012-4-3
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
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
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

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by