The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"Multiple tabs in excel files"
Guru
Hi, how can I work with an excel file with multiple tabs without changing tab every time I want to make a change?
When I have different excel files I can use loop file operator, but the problem is when I have one excel with many tabs.
Thanks in advance.
When I have different excel files I can use loop file operator, but the problem is when I have one excel with many tabs.
Thanks in advance.
Tagged:
0
Best Answer
-
yyhuang
Administrator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 364 
RM Data Scientist
Hi @Papad,
if you would like to read the excel sheets one by one, you can iterate the sheet number in “Read Excel”. You can use a list of sheet name to apply a loop or use sheet number as iteration count.
Enjoy!
YY7
Answers