Using xlsread in a for loop

4 views (last 30 days)
Benjamin on 9 Nov 2018
Answered: Rik on 10 Nov 2018
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?

Answers (1)

Rik on 10 Nov 2018
If the worksheet names are 0.600 etc you can use the code below.
for n=20:-1:1
A= xlsread(filename,sprintf('0.6%02d',n));

Community Treasure Hunt

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

Start Hunting!