Want to get the name of current active worksheet in excel

[AryanSingh]

Hello Everyone

I want to get the name of only the current active worksheet present in an excel workbook.

Is there any way to do that without using macro.

Like, in the screenshot below, the Sheet1 is active.

screenshot below, the Sheet2 is active.

So, for number one, I need this active sheet names.

@Palaniyappan
@ImPratham45

Do you have any insight in this case? if yes, please help.

Thanks & Cheers

[AshwinS2 (Ashwin S)]

Hi @AryanSingh
1.use read range and pass the sheet name
2.Use excel application scope and pass the path of the excel and create a workbook variable in excel application scope workbook property.
3.use for each item in wb.GetSheets
4.print the item in message box

Thanks
Ashwin S

Thanks
Ashwin S

[Palaniyappan (Palaniyappan P)]

Hi
Kindly have a view in this thread

Get Active Sheet Name

You might investiate using an XLS macros to get the sheet name (macro, sheet name) Or you might go the image-automation route: Find the images that correspond to a selected sheet, then scrape between them

Cheers @AryanSingh

[kuppu_samy]

@AshwinS2

1.use read range and pass the sheet name
2.Use excel application scope and pass the path of the excel and create a workbook variable in excel application scope workbook property.
3.use for each item in wb.GetSheets

Get the sheet Name by wb.CurrentWorksheet.Name

[AryanSingh]

@kuppu_samy

Hello

I have tried with your way, but its giving me an error.

Thanks

[AryanSingh]

@Palaniyappan

Want to get the name of current active worksheet in excel

Hi Kindly have a view in this thread Cheers @AryanSingh

I can’t use the macro, that is why I am saying without macro.
How can we get current worksheet without using macro?

Thanks
Aryan

[AryanSingh]

@kuppu_samy

Check the issue above.

Thanks & Regards
Aryan

[Palaniyappan (Palaniyappan P)]

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 variable named str_input

Cheers @AryanSingh

[AryanSingh]

@Palaniyappan

Ok, its a long process but I think it will work

Let me try.

Thanks.

[Palaniyappan (Palaniyappan P)]

Yah it would @AryanSingh

[Palaniyappan (Palaniyappan P)]

Is it working @AryanSingh

[AryanSingh]

@Palaniyappan

Want to get the name of current active worksheet in excel

Is it working @AryanSingh

Its working. Now I remember, that the shortcut keys are from the past solution of copying sheets and renaming them.

Copy and paste sheet in the same excel file with new name after/before a particular sheet

@ALL Hello guys, I have an excel file in that, I have various sheets. And I want to copy the a particular sheet and paste that sheet with previous values in the new sheet also but with a different name. Example: Suppose their is a sheet name Oct 2019 and I want to copy this sheet and create same sheet with new name Nov 2019. Manual Steps : Ctrl + Left Mouse Click and Hold and drag to the Right. I am not sure how to do this using UiPath. Please check the images below for better under standi…

@kuppu_samy
@Palaniyappan
@AshwinS2

Thanks & Cheers
Aryan