how to read the ms excel numeric data?

3 Ansichten (letzte 30 Tage)
bsd
bsd am 3 Apr. 2012
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

Melden Sie sich an, um diese Frage zu beantworten.

Antworten (2)

Andrei Bobrov
Andrei Bobrov am 3 Apr. 2012
try use
z = xlsread('E:\ac.xls'))
  3 Kommentare
1 älteren Kommentar anzeigen
bsd
bsd am 3 Apr. 2012
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 am 3 Apr. 2012
your file 'ac' save as '.xls'

Melden Sie sich an, um zu kommentieren.

som
som am 3 Apr. 2012
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 Kommentare
bsd
bsd am 3 Apr. 2012
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 am 3 Apr. 2012
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

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Spreadsheets finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by