How to rename the specific sheet on excel?

excel
activities

#1

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.


#2

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

HI @arivu96,

thank you, Very good my friend

regards.


#4

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.


#5

very good,

thank you for you input.

regards.


#6

Hi @elvbis,

Hi ,

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

Regards
Balamurugan.S


#7

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

DV