how to read the ms excel numeric data?
3 次查看(过去 30 天)
显示 更早的评论
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 个)
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
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!