change variable and assign to dataset in each loop

1 次查看(过去 30 天)
Hello,
I have one excel file that contains 12 sheets. Each sheets contains 5 columns I want to read each sheet and put in one dataset. So, I am thinking is it possible for me to create for loop in order to have 12 datasets.
as an example:
for sheet=1:12;
%import excel file (sheet)
% A(sheet)= dataset(column1, column2, column3, column4, column 5)
end

采纳的回答

Iain
Iain 2013-6-24
Three approaches
for i = 1:12 %(Sheets not the same size)
[numbers{i} texts{i} raws{i}] = xlsread(....);
end
Or
for i = 1:12 %(All sheets same size)
numbers(:,:,i) = xlsread(...)
end
Or
numbers = [];
for i = 1:12 %(All sheets same size)
n = xlsread(...);
numbers = [numbers; n];
end

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by