How to rename the specific sheet on excel?

hi everyone,

i have a problem , when i am trying rename my workbook but the specific sheet i need rename a specific sheet for example, oldSheet with newSheet, what is the idea, please help me.

regards.

Hi @elvbis,

you can refer this post @aksh1yadav

Refer this xaml and you need to modify little bit.

  • In Excel Application scope activity-> Properties-> Visible need to check
  • use Read cell activity to active the specific sheet
  • at end of the Excel application scope use Ctrl+S send hot key to save

Regards,
Arivu

3 Likes

HI @arivu96,

thank you, Very good my friend

regards.

1 Like

It might be better to use Select Range to select your sheet. You can hardcode the name or using a WorkbookApplication variable (wb for example) you can access the sheet names in an array. wb.GetSheets(0) would give you the first sheet.

very good,

thank you for you input.

regards.

1 Like

Hi @elvbis,

Hi ,

Here I have attached a custom activity to rename the excel sheet.

Regards
Balamurugan.S

2 Likes

Hi,
I have the custom activity for this. Let me know if you need that.

DV

Hi @deepak1745
I need that

Can u explained, how to use that custom activity in my workflow

Hi,

Do you need the nuget package with “Rename Excel sheet” Activity?

Deepak

Hi @balupad14

I’m Getting error when I’m opening your workflow , please can you explain how to insert that

"Could not find type ‘BalaReva.Excel.Others.RenameSheet’ in assembly ‘BalaReva.Excel’. "

error1

Install the package from community. You can see the activity!

hi,

download this component https://github.com/inforoy/UipathExcelUtility/tree/master/nuget%20package and install in your studio and use component called RenameSheet it is very simple.

Hi ,
I have attached a video for you reference to do the renaming work sheet.

Regards
Balamurugan.S

2 Likes