UiPathGo - BalaReva Excel Activities

Hello Friends,

I have successfully uploaded the BalaReva XL Activities in UiPath Go.

This package contains more than 30 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.


This package is having the below activities.

image


Here is the video that how to remove the Hyperlink from excel sheet.

UiPath Go Version : 2019.4.0
Latest Package : BalaReva.Excel.Activities.2019.6.0.nupkg (54.2 KB)

Regards
Balamurugan.S

4 Likes
Copy/Move Excel Sheets to Other WorkBook
Copy one sheet to another workbook with same format
How to copy paste an image into an excel file and how to paste those images in different sheets of the same excel?
Excel Graph creation with UiPath
Excel link break
Create new excel
Get sheet name and info without using Excel application scope
If uipath can build more activities about EXCEL
If uipath can build more activities about EXCEL
Rename a sheet in workbook
Copy excel cover sheet with images and formulas to a new excel
INSERTING AN IMAGE INTO AN EXCEL SHEET WITHOUT OPENING IT
Adding/Insert an Images to Excel
Copying one whole row of a Data Table
How to copy data from one excel workbook to another excel workbook
Get the wrong sheet name when reading and writing the data in the New excel workbook
Problem with Password Protected Excel file
Convert column to number, without open the excel file
Piechart from excel without macros
Copy pasting multiple images in excel
Select excel column in excel
BalaReva.Excel.Activities Continue
Email body to excel
Copying a whole row of one excel sheet and paste it in other sheet
Need to copy few cells in Excel then past the same in notepad
Copy and Paste table from excel to notepad
Add password to Excel file
Rename sheets in excel
How to remove duplicates entries from Row and it should remove that entire Column
Remove Duplicates from Excel
How to unhide sheets present in the excel and Hide back the same sheet
Excel link break
Adding and renaming excel sheet in a workbook

Hi @Andreea_Stroe

I am getting version differentiation between UiPath go(19.0.0) and UiPath Studio(2019.1.3) Manage package. Can you please take look on it.

Studio :

UiPath Go :

Regards
Balamurugan.S

1 Like

Hi ,
I have included a new activity in the version 19.0.0 called InsertImage at cell. I don’t want to explain it. you can understand the meaning of this activity by the name.

image

Regards
Balamurugan.S

2 Likes

Hi Balamurugan,

Thank you for bringing this to my attention. We will look into this and keep you posted!

Best Regards,

Andreea & Go! Team

Obțineți Outlook pentru Android

3 Likes

Thank you @Andreea_Stroe

1 Like

Hi Balamurugan,

We have checked and we believe we have identified the issue.
First of all, you have submitted a new version of the component, 20.0.0, which has passed all our tests and has been published in Go!. This version is present in Studio, but does not appear as the current version due to its version number.
Since the other component versions have 2019. at the beginning, we kindly recommend to change the version from 20.0.0 to 2019.2.0, to keep the same style as the other version. This way it will appear in Studio as the current version of the component.

Best Regards,
Andreea & Go! Team

2 Likes

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