how to read the ms excel numeric data?

bsd
2012 4 3
2 个回答
6 次查看（30 天）

0 个投票

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

0 个投票

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

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

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.
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
Andrei Bobrov
Andrei Bobrov 2012-4-3
your file 'ac' save as '.xls'

请先登录，再进行评论。

som
som 2012-4-3

0 个投票

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

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

提问:

bsd
bsd
2012-4-3

Community Treasure Hunt

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

Start Hunting!

Translated by