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 these activities you can able to generate the Column Chart
  • Line Chart - Using these activities you can able to generate the Line Chart
  • Bar Chart - Using these activities you can able to generate the Bar Chart
  • Add Comment - Add the comment in specific cell
  • Get Comment - Read the comment for the cell
  • Delete Comment - Delete the comment in the cell
  • Show/Hide Comment - Show or hide the comment
  • Copy Data to Clipboard - Copy the data to clipboard
  • Clipboard To Datatable - Convert the clipboard data to data table
  • Delete Data - Delete or clear the cell
  • Hide / Unhide Column - Hide or unhide the columns
  • Hide / Unhide Row - Hide or unhide the rows
  • Merge Cells - Using this activity can merge cell range
    Features : with VerticalAlignment and HorizontalAlignment Selection
    Right , Left , Justify , Distributed ,Center ,General ,Fill,CenterAcrossSelection
  • UnMerge Cells - Using this activity can unmerge cell range
    Features : with VerticalAlignment and HorizontalAlignment Selection
    Right , Left , Justify , Distributed ,Center ,General ,Fill,CenterAcrossSelection
  • AutoFit Columns - Auto fit the column and also can adjust column width
  • AutoFit Rows - Auto fit the row and also can adjust row height
  • Change Cell Type -Format the numbers in cells
    for things like currency, percentages, decimals, dates, phone numbers, or social security numbers.
  • Copy To File - Copyt work sheet to one file to another file
  • Delete Sheet- Delete the sheet from workbook
  • Extract Graph Image - Extract all graph as images (Bmp , Gif , Jpg , Png)
  • Find Replace- Find and replace text in the cell range
  • Format Cells- Format the cell or cell range - Alignment
    Horizontal alignment - Right , Left , Justify , Distributed ,Center ,General ,Fill,CenterAcrossSelection
    Indent
    Verticle alignment - Top , Justify , Distributed , Center ,Bottom
    Text Control - WrapText , ShrinkFit , MergeCells
    Text Direction - RightToLeft , LeftToRight , Context
    Orientation degrees
  • HideUnhide - Hide or unhide the sheet in the workbook
  • Hyperlink Remove - Remove the hyperlink from the cell range
  • Insert Image - Insert the image in a position (Top ,Left , Height and width )
  • Insert Image At Cell - Insert the image in a position of cell
  • Insert Table Format - Insert or create a table with 28 formats
  • Remove Duplicates - Remove the duplicates option with multiple columns
  • Add Sheet - Add a new sheet in excel
  • Copy To WorkBook - Copy the worksheet with in workbook
  • Create WorkBook - Create a new workbook or excel file
  • Export WorkBook - Export work in ( pdf , xps ) option with cell range
  • Get Sheets Name - Get Sheets Names from excel
  • Protect UnProtect - Protect or UnProtect the sheet
  • Rename Work Sheet - Rename the work sheet
  • Set Password- Set the password to the work book or excel file
  • Set (Change) table format -

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

Regards
Balamurugan.S

20 Likes

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 :

https://go.uipath.com/component/balareva-xl-activities#

Regards
Balamurugan.S

6 Likes

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

7 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

6 Likes

Thank you @Andreea_Stroe

4 Likes

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

4 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

4 Likes

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

3 Likes

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.

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

7 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