Rename sheets in excel

[borismh (Boris)]

Lectura de archivos exitosa.zip (121.3 KB)
good afternoon
I would like to know a way to change the excel sheets for the names of my files while reading these in a folder
just get them to put the name “sheet01”, “sheet02” and so
my work reads a folder of xml files and then through a for each write on each sheet the name and path of these xml, I would like that apart from that also write the name of the xml on the excel sheets, so that be easier to look for.
Thank you very much, if there can be a solution for my problem

[Palaniyappan (Forum Leader)]

Hi
did we try with the methods in this blog

Renaming an Excel sheet

Hi, UiPath does not have an activity to rename sheets yet. Perhaps you can treat the problem as follows: Read the Excel sheet and save it in a new Excel. (WriteRange activity automatically creates Excel and sheet) [image] I hope it helps you

Cheers @borismh

[borismh (Boris)]

@Palaniyappan
It is not the solution, please look at my workflow

[AshwinS2 (Ashwin S)]

Hi @borismh

There is an activity by name rename sheet you can have a glance

Thanks
Ashwin.S

[borismh (Boris)]

@AshwinS2
Is it in an activity pack?

[sarathi125 (Parthasarathi)]

@borismh,

Check this custom activity

https://go.uipath.com/component/excel-extension-activities

[borismh (Boris)]

@Palaniyappan @AshwinS2 @sarathi125
please review my work that I attached to the beginning

[balupad14 (Balamurugan)]

Hi @borismh,

Here is an activity called rename worksheet to rename the worksheet.

BalaReva.Excel.Activities

Hi Friends, I have included a new activity that to rename the excel sheet’s name. “Rename Work Sheet.” Namespace : [image] Properties: [image] Sample File : RenameExcelSheet.zip (38.8 KB) Let me if you have any errors. I would be happy to get more suggestions . Regards Balamurugan

Latest :

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Regards
Balamurugan.S