borismh
(Boris)
November 26, 2019, 3:19pm
1
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
1 Like
Hi
did we try with the methods in this blog
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)
November 26, 2019, 3:32pm
3
@Palaniyappan
It is not the solution, please look at my workflow
AshwinS2
(Ashwin S)
November 26, 2019, 3:45pm
4
Hi @borismh
There is an activity by name rename sheet you can have a glance
Thanks
Ashwin.S
borismh
(Boris)
November 26, 2019, 3:50pm
5
@AshwinS2
Is it in an activity pack?
sarathi125
(Parthasarathi)
November 26, 2019, 3:52pm
6
borismh
(Boris)
November 26, 2019, 4:56pm
7
@Palaniyappan @AshwinS2 @sarathi125
please review my work that I attached to the beginning
balupad14
(Balamurugan (BalaReva))
November 26, 2019, 5:03pm
8
Hi @borismh ,
Here is an activity called rename worksheet to rename the worksheet.
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 :
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
2 Likes