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?

[Doug Hull]

What is happening when you fail? When you say "read as a matrix" do you mean "read as a vector"?

[Mtlb Usr]

Exactly, when I said "read as a matrix" I would want to say "..as a vector".

Answer 1

[the cyclist]

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

[Davide Ferraro]

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.

Answer 2

[Mtlb Usr]

I'm not using a Mac.

Answer 3

[Davide Ferraro]

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).