Is it possible to read multiple sheets in a for loop?
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?