Read active sheet in excel

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.

Hi,

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)

Regards,

3 Likes

Hi @shruti_kansakar

You can try this

  1. Get Workbook Sheet - It will get the name of the sheets
  2. 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

  1. Goto → Filters-> Check on Show StudioX
  2. Search for for each file
    image
  3. Take the Activity give the path and filter like you want

Regards
Sudharsan

1 Like

Sheets activity was the answer I was looking for.

Thanks.