How to get Active sheet name ? .. Help

[ABHI_S (Abhi)]

How to get active worksheet name … I have used Workbook(Variable).Currentworksheet.name and I’m getting nothing in return

[Pratik_Wavhal]

Hi @ABHI_S

Have a look to the below thread :-

Want to get the name of current active worksheet in excel

Awesome Let me tell you how to do that —use Start process activity and pass the file path of excel as input —now this will open the file in foreground —then use SEND HOT Key Activity and mention the key as alt+h without any selector chosen —now use another send hot key activity with key o (Not zero its o) —and another send hot key activity with key as r —then a final send hot key with key as ctrl+c —now use a GET FROM CLIPBOARD activity and get the output from clipboard with a string va…

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[ManiPrajwal_K (Mani Prajwal Katta)]

Hai @ABHI_S,

You can go with VBA script:

ActiveSheet.Name, vbInformation, "Active Sheet Name"

To return the name of the worksheet name to UiPath from the Macro:

Private Function SheetNameMacro() As String
'
' SheetNameMacro Macro'

'
Dim SheetName As String
SheetName = ActiveSheet.Name, vbInformation, "Active Sheet Name"

SheetNameMacro = SheetName 
End Function

SheetNameMacro is the function name and also the return value. This value will be returned to UiPath Macro Output variable

To get all the worksheets names in a Workbook you can follow the below procedure:

You have to use “Excel Application Scope” activity O/P variable. i.e of type UiPath.Excel.WorkbookApplication.

Now you have to use the expression:
WorkbookApplicationVariable.GetSheets

Loop through the variable holding values from the above expression. you can get all the worksheets names.

Hope this solves your query!

Cheers!!

[varunk (Varun Kumar)]

We have direct activity to get the sheet name

[ManiPrajwal_K (Mani Prajwal Katta)]

@varunk Wow Sounds great!! Could you please provide more details about the suggested activity?

[varunk (Varun Kumar)]

Please find the below attachment fir your reference,

[ABHI_S (Abhi)]

still we have to provide index in this field, we are talking about active sheet

[varunk (Varun Kumar)]

Yes absolutely to get the sheet name you require index number