Hi Balamurugan,
I will write to you from Atlassian and if you possible, please provide the files there for us to have a look.
Thank you,
Andreea & Go! Team
4 Likes
Hi @Andreea_Stroe,
Already I have reported this issue in the id GSD-1239 on July 21st 2019.
Regards
Balamurugan.S
4 Likes
Hi Balamurugan,
I have just sent you a message in Atlassian. You can provide the files there for us to have a look and I will update the component.
Best Regards,
Andreea & Go! Team
3 Likes
Hi Balamurugan,
The reference number for the ticket is GSD - 115.
Best Regards,
2 Likes
Hi ,
In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below.
In the Cell Format , can specify the custom format what we have in the excel Like below image.
Sample : UiPathGoExcel.zip (18.4 KB)
This is the video to configure the package in local.
Here is the link to know about the formats.
Regards
Balamurugan.S
6 Likes
Here I have attached the Video for File Copy Activity
Regards
Balamurugan.S
4 Likes
Hi,
Here I have attached the rename the worksheet video.
Regards
Balamurugan.S
4 Likes
Hi,
Here is a sample project for find and replace string in the excel.
ExcelFindReplace.zip (18.5 KB)
Regards
Balamurugan.S
5 Likes
Hi,
I have an excel sheet,can you help me put one value in just one cell.I will be attaching the excel sheet.output.xlsx (8.9 KB)
3 Likes
Hi @Kartika,
To write a particular or one cell , you can use the “write cell” activity
Regards
Balamurugan.S
5 Likes
No,I mean that there are multiple values in my cell,I want one value in one cell at a time
2 Likes
I understand your problem …
4 Likes
Hi @Kartika,
Here I have attached the Project zip along with output.xlsx.
Karthika.zip (27.9 KB)
Note :
If you have any doubts let me with tomorrow.
Regards
Balamurugan.S
4 Likes
Thanks man, it really has saved me today!!!
I spent more than three hours trying to do it on excel!
4 Likes
Hi,
Here is the information about the Autofit column and row…
you can get the package like below in the studio.
The activities are :
Properties
Here you have an option to specify the Column Width instead of AutoFit
Here you have an option to specify the Row Height instead of AutoFit
Thank you
Balamurugan.S
4 Likes
Hi All,
I have done a major changes in the BalaReva.Excel.Activities that allows the property value empty to Sheet Name and Cell Range.
If the sheet name is empty , It will take the first sheet name automatically.
If the Cell range is empty , It will the used range.
I have attached the package in the first thread.
I have tagged a user @VanessaCova …
Thank you
Balamurugan.S
3 Likes
Hi,
I have included a new activity called “Export WorkBook”. Using this activity that can able to export the workbook as PDF and XPS.
Name Space :
Activity and Properties :
Note :
Let me if you have any errors.
I would be happy to get more suggestions and feedback (Possibly likes).
Here is the video demonstration also.
Regards
Balamurugan.S
7 Likes
Hi,
I have developed a new activity called “Extract Graph Image” to extract the all the graphs as a images. It has the option to extract various format (bmp,gif,jpg,png)
Namespace :
Activity and Properties :
Note :
Let me if you have any errors.
I would be happy to get more suggestions and feedback (Possibly likes ).
Regards
Balamurugan.S
4 Likes
Hello @balupad14
Thank you so much for your project on the package, it has helped a lot.
But could you please tell me on how to copy different range to clipboard eg: “E1:E29,H1:I29”?
Currently if I enter the above range its copying the complete range from “E1:I29”.
3 Likes
Hi @syedaquib77
Welcome to you UiPath Forum Community !
Can not copy multiple range at a time. You can copy multiple range one by one or like below.
Sample : syedaquib77.zip (19.8 KB)
Regards
Balamurugan.S
4 Likes
mpraveen1902
Palaniyappan
Parvathy
Anil_G
Swathi_Raju
Sara_Piana
Yoichi
Nitya1
ashwin.ashok
Rishita_aggarwal