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

 Réponse acceptée

Mischa Kim
Mischa Kim le 21 Fév 2014
Modifié(e) : Mischa Kim le 21 Fév 2014

0 votes

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 commentaires

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

Connectez-vous pour commenter.

Plus de réponses (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by