Xlsread command in Matlab

6 次查看(过去 30 天)
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
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 个)

标签

Community Treasure Hunt

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

Start Hunting!

Translated by