Read many column from excel sheet
2 次查看(过去 30 天)
显示 更早的评论
I have to read from an excel sheet many columns, and each column has to be assigned to a variable, for example first column is firstmatrix, etc. I wrote the following code but it only read one column. I have no idea how can I read all columns not manually!
[filename, pathname] = uigetfile('*.xlsx','Load Dataset');
if filename==0
msgbox('Please Choose Dataset','Error','Error')
return
end
A = xlsread(filename,'Sheet1','C17:C46');
disp(A);
1 个评论
MBD4FUN
2016-4-3
Why don't you just read the entire sheet and extract data by column later? Don't know if the following is what you want but might give you some hint.
% Get all data from sheet
[~,~,alldata] = xlsread(filename,'Sheet1');
% Set column to variables
A = alldata(:,1);
B = alldata(:,2);
...etc,.
Or simply using a for-loop to iterate through columns of the alldata cell array to get what you are looking for.
Happy Scripting!
MBD4FUN
回答(1 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!