Using xlsread in a for loop

2018 11 9
1 个回答
更新时间：2018 11 10
3 次查看（30 天）

0 个投票

I have this code:
filename = 'C:\PATH\variable_analysis.xlsx';
A= xlsread(filename,'0.600');
But I want to read in 20 worksheets (0.601, 0.602, ... 0.620) Can I do this in a for loop and create a struct that contains the matrix from each worksheet?

请先登录，再回答此问题。

回答（1 个）

Rik
Rik 2018-11-10

1 个投票

If the worksheet names are 0.600 etc you can use the code below.
B=struct;
for n=20:-1:1
A= xlsread(filename,sprintf('0.6%02d',n));
B(n).data=A;
end

类别

在 帮助中心 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

提问:

Benjamin
Benjamin
2018-11-9

回答：

Rik
Rik
2018-11-10

Community Treasure Hunt

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

Start Hunting!

Translated by