Hi all, I need to get the current active sheet name when opening an excel file. This sheet name could be different for each workbook that is opened. I tried using the excel application scope, assigning the output workbook… then assigning a str → wb.CurrentWorksheet.Name however I am receiving the…

Hi, The following might help you. [image] Read active sheet in excel Studio Hi, There are some ways to achieve it. The following is one of them using ClosedXML. Hope this helps you. [img20210820-1] Sample20210820-1.zip (16.9 KB) Regards, Regards,

Excel - Get current active sheet name

Help Studio

Yoichi (Yoichi) August 20, 2021, 2:34pm 2

Hi,

The following might help you.

Regards,

Topic		Replies	Views
How to get the name of the opening sheet in excel? Studio excel , uiautomation , activities	7	2042	May 11, 2020
Want to get the name of current active worksheet in excel Help excel , activities , question	11	5768	December 20, 2019
How to get current shet name Studio excel , activities , studio , question , use-excel-file , excel-scope , for-each-row , excel-automation , for-each-sheet	7	274	May 7, 2026
How to get Active sheet name ? .. Help Activities excel , activities	7	4394	October 1, 2020
Get Excel workbook active sheet name without opening file Help	5	4273	April 29, 2019

Excel - Get current active sheet name

Related topics