Read each columns of xls,csv,... as a matrix

1 次查看（过去 30 天）
Mtlb Usr
Mtlb Usr 2011-1-31
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?
  2 个评论
Doug Hull
Doug Hull 2011-2-2
What is happening when you fail? When you say "read as a matrix" do you mean "read as a vector"?
Mtlb Usr
Mtlb Usr 2011-2-3
Exactly, when I said "read as a matrix" I would want to say "..as a vector".

请先登录，再进行评论。

请先登录，再回答此问题。

回答（3 个）

the cyclist
the cyclist 2011-2-2
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
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.

请先登录，再进行评论。

Mtlb Usr
Mtlb Usr 2011-2-3
I'm not using a Mac.
Davide Ferraro
Davide Ferraro 2011-2-3
To read an Excel file you should use XLSREAD:
http://www.mathworks.com/access/helpdesk/help/techdoc/ref/xlsread.html
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).

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by