UiPathGo - BalaReva Excel Activities

Thank you @Andreea_Stroe,

Yes. It is fixed. I will upload a new version with 2019.2.0. I will follow the same to all my packages.

Thank you
Balamurugan.S

1 Like

Hi @Andreea_Stroe,

I try to upload the version 2019.2.0. But i can not able.When I click the Upload Component. Nothing is happened. please check it. below some screen shot for your reference.

Regards
Balamurugan.S

1 Like

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

2 Likes

Hi @Andreea_Stroe,

Already I have reported this issue in the id GSD-1239 on July 21st 2019.

Regards
Balamurugan.S

1 Like

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

1 Like

Hi Balamurugan,

The reference number for the ticket is GSD - 115.

Best Regards,

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.

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

3 Likes

Here I have attached the Video for File Copy Activity

Regards
Balamurugan.S

1 Like

Hi,
Here I have attached the rename the worksheet video.


Regards
Balamurugan.S
1 Like

Hi,
Here is a sample project for find and replace string in the excel.

ExcelFindReplace.zip (18.5 KB)

Regards
Balamurugan.S

2 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)

1 Like

Hi @Kartika,

To write a particular or one cell , you can use the “write cell” activity

Regards
Balamurugan.S

2 Likes

No,I mean that there are multiple values in my cell,I want one value in one cell at a time

I understand your problem …

1 Like

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

1 Like

Thanks man, it really has saved me today!!!

I spent more than three hours trying to do it on excel!

1 Like

Hi,
Here is the information about the Autofit column and row…

you can get the package like below in the studio.

The activities are :

image

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

1 Like

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

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).

Regards
Balamurugan.S

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