Read each columns of xls,csv,... as a matrix
显示 更早的评论
I have got a several CSV and XLS files and I want to read with a MATLAB wizard to read each column as a matrix.
I have tried it with these files and only I got it with csv file.
What is the rule for read these files in this way?
回答（3 个）
the cyclist
2011-2-2
0 个投票
Are you using a Mac? Macs can't read Excel files:
http://www.mathworks.com/support/solutions/en/data/1-2SJUON/index.html?solution=1-2SJUON
1 个评论
Davide Ferraro
2011-2-3
XLSREAD is able to read Excel file also on MAC OS. You won't obtain all the functionalities related to the COM (that's available only on Windows OS) but you will still be able to read the file in basic mode.
Davide Ferraro
2011-2-3
To read an Excel file you should use XLSREAD:
The syntax:
[num,txt,raw] = xlsread(filename,range)
allows you to select a specific range. This should be a string with the same format you would use in Excel (e.g. 'B2:B8' to read from cell B2 to cell B8).
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
