Problem regarding reading excel file in a loop
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!