Renaming a sheet in Excel

Help
1

How to rename a sheet in Excel ? Can we do this using hotkeys ?

Thanks.

1 Like
2

Check this out … you would need to use hotkeys Renaming an Excel sheet - #3 by aksh1yadav

1 Like
3

Hi ,

Here is an activity to rename the excel sheet.

Regards
Balamurugan.S

1 Like
4

@balupad14
Balu I’m getting Error,
Capture

How to include that activity into my Project

5

let me check and get back to you !

Regards
Balamurugan.S

6

Hi @ChinnapuReddy,

I don’t know what happened with old. But here I have attached a new sample. It is working well.

RenameSheet.zip (8.4 KB)

Regards
Balamurugan.S

7

@ balupad14
Balu I’m getting same error
I’m using 2017 studio, same error occurred

Bala1
Bala11364Ă—731 35.1 KB

Before using this activity , I need to update activities or import . let me know balu

8

You probably need to go to the Activities and install his package from the Community Feed.

You can configure the Community Feed source by right clicking on “Available” and choose Configure Sources:
image

Then, go to the feed and look for his packages.

image
image904Ă—475 48.9 KB

Then, close the workflow and reopen.

I hope that helps solve your issue.

If you don’t want to use his activities, the alternate methods would either be to use “Invoke VBA” activity to rename the sheets or use the Alt-key combination inside the Excel file which would be “[k(alt)]hor” or “[k(alt)]horNEWNAME[k(enter)]”

Regards.

1 Like
9

Hey,

Actually my Studio is 2017 version, so that I don’t have that option in studio, please upload the documents for this query

some one guide me

10

Hi @ChinnapuReddy

The option to use the Community Feed and install Bala’s activities should be available in 2017. Invoke VBA won’t be though. Also, you can take the Type Into approach as well that I mentioned by using Alt-combo.

Let me know if you still can’t install Bala’s activities or if you need further help with that. You basically need to go to the Activities tab and find the button that says Packages at the top of the Activities tab, then follow the screenshots I provided to bring in the Community Feed.

If you would like to take the Type Into approach, let me know and I can provide an example screenshot on how to set that up.

Regards.

11

Hi @ClaytonM @susbasu

Here’s a code using UiPath.Excel activities. Used an invoke method activity. Goes well within an Excel application scope. :grinning:Rename_Excel.zip (15.8 KB)

1 Like