Problem regarding reading excel file in a loop

2 次查看（过去 30 天）
Prakhar Modi
Prakhar Modi 2019-8-27
回答： emjey 2019-8-27
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

请先登录，再回答此问题。

采纳的回答

emjey
emjey 2019-8-27

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by