Xlsread command in Matlab
1 view (last 30 days)
Show older comments
How Can I extract each columns with the xlsread command.
for i1 = 2:n1+1
matrix = xlsread();
end
0 Comments
Accepted Answer
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.
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!