Problem regarding reading excel file in a loop

Hello everyone,

Is it possible to read multiple sheets in a for loop?

For example

I have a Excel file with sheets as sheet 1, sheet 2, sheet 3, sheet 4 and so on.

now as we usual use

xlsread('filename','sheet','range')

but is this possible is someway or other

for i=1:5 %lets say I have 5 sheets name from sheet 1 to sheet 5

xlsread('filename','sheet i','range') %here filename is same and range is same but I want that as i increases the sheet i also gets change. Is it possible?

end

Answer 1

[emjey]

It seems your issue was answered here

https://uk.mathworks.com/matlabcentral/answers/349109-read-in-excel-sheets-with-a-loop