Read many column from excel sheet

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);

[MBD4FUN]

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

Answer 1

[Azzi Abdelmalek]

If you want all columns

A = xlsread(filename);