Hi @Page0727 , can you show us how your Excel Reader is configured?
It sounds like you are not reading the sheets dynamically within the Loop.
You need to make sure that you use these settings:
- In the Settings tab, choose the “Select sheet with name” option (don’t mind what’s in the drop down, we will override it in the next step)
- In the Flow Variables tab, select your variable that contains the sheet name from the drop down from the “sheet_name”. This variable will dynamically change value within your loop
After all this, you should see this message at the bottom of the Excel Reader on the Settings tab:
