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

Answer 1

[Andrei Bobrov]

try use

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

[bsd]

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]

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]

your file 'ac' save as '.xls'

Answer 2

[som]

 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

[bsd]

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]

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