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

4 visualizzazioni (ultimi 30 giorni)
Mtlb Usr
Mtlb Usr il 31 Gen 2011
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 Commenti
Doug Hull
Doug Hull il 2 Feb 2011
What is happening when you fail? When you say "read as a matrix" do you mean "read as a vector"?
Mtlb Usr
Mtlb Usr il 3 Feb 2011
Exactly, when I said "read as a matrix" I would want to say "..as a vector".

Accedi per commentare.

Risposte (3)

the cyclist
the cyclist il 2 Feb 2011
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 Commento
Davide Ferraro
Davide Ferraro il 3 Feb 2011
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.

Accedi per commentare.


Mtlb Usr
Mtlb Usr il 3 Feb 2011
I'm not using a Mac.

Davide Ferraro
Davide Ferraro il 3 Feb 2011
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).

Community Treasure Hunt

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

Start Hunting!

Translated by