Problem regarding reading excel file in a loop

3 views (last 30 days)
Prakhar Modi
Prakhar Modi on 27 Aug 2019
Answered: emjey on 27 Aug 2019
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
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?

More Answers (0)





Community Treasure Hunt

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

Start Hunting!

Translated by