Read many column from excel sheet

1 次查看（过去 30 天）
Ali Jaber
Ali Jaber 2016-4-3
评论： MBD4FUN 2016-4-3
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
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 个）

Azzi Abdelmalek
Azzi Abdelmalek 2016-4-3
If you want all columns
A = xlsread(filename);

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by