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

 採用された回答

Mischa Kim
Mischa Kim 2014 年 2 月 21 日
編集済み: Mischa Kim 2014 年 2 月 21 日

0 投票

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 件のコメント

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

サインインしてコメントする。

その他の回答 (0 件)

タグ

質問済み:

2014 年 2 月 11 日

コメント済み:

2014 年 2 月 21 日

Community Treasure Hunt

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

Start Hunting!

Translated by