Hi, I have a folder with multiple excels. How can I read all active tab/sheet from each excel ? The names in each excel’s tab are different eg( Cali price, NY price). Is there a dynamic way to do this ? Also, there is only 1 active sheet in each excel.
There are some ways to achieve it. The following is one of them using ClosedXML.
Hope this helps you.
Sample20210820-1.zip (16.9 KB)
You can try this
- Get Workbook Sheet - It will get the name of the sheets
- Use For Each- Loop it in sheet name and make condition to find the Active sheet and use read range inside if
For taking all the excels in the Folder Follow the steps
- Goto → Filters-> Check on Show StudioX
- Search for for each file
- Take the Activity give the path and filter like you want
Sheets activity was the answer I was looking for.