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.

Sheets activity was the answer I was looking for. Thanks.

Read active sheet in excel

Yoichi (Yoichi) August 19, 2021, 11:32pm 2

Hi,

There are some ways to achieve it. The following is one of them using ClosedXML.
Hope this helps you.

Regards,

3 Likes

Excel - Get current active sheet name

Forum Engagement Daily Reports

Read range workbook

Topic		Replies	Views
How can I read all .xlsx files in a folder and read tab names from each excel Studio excel , activities , studio	18	1334	September 17, 2022
How to get data table of active sheet in excel Help	4	3819	May 25, 2018
Get value in active sheet Studio	1	626	June 12, 2020
Read Excel SheetName Dynamic Help	4	1539	April 7, 2019
Excel - Get current active sheet name Studio	3	1635	August 20, 2021