MATLAB Answers

Problem regarding reading excel file in a loop

1 view (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
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

  0 Comments

Sign in to comment.

More Answers (0)

Tags

Products


Release

R2018a

Translated by