change variable and assign to dataset in each loop

1 次查看（过去 30 天）
Reyasudin
Reyasudin 2013-6-24
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 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