Xlsread command in Matlab

How Can I extract each columns with the xlsread command.
for i1 = 2:n1+1
matrix = xlsread();
end

 Accepted Answer

Mischa Kim
Mischa Kim on 21 Feb 2014
Edited: Mischa Kim on 21 Feb 2014
Francesco, with xlsread you read the entire spreadsheet. Which means, that you can read an entire matrix as is, at once. E.g., from the MathWorks documentation:
values = {1, 2, 3; 4, 5, 6; 7, 8, 9}; % write matrix to .xlsx file
headers = {'First','Second','Third'};
xlswrite('myExample.xlsx', [headers; values]);
and then
filename = 'myExample.xlsx'; % read matrix from file
A = xlsread(filename)
1 2 3
4 5 6
7 8 9
as expected, A is read as a 3-by-3 matrix.

2 Comments

Kim, this question is not very important. It's a old matter. But I am happy that you reply me! Thanks!
I would like to say you if it's very difficult to reply at this questions? Can I hear you opinion?

Sign in to comment.

More Answers (0)

Tags

Asked:

on 11 Feb 2014

Commented:

on 21 Feb 2014

Community Treasure Hunt

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

Start Hunting!