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.


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

14 Likes
How to copy paste an image into an excel file and how to paste those images in different sheets of the same excel?
Copy/Move Excel Sheets to Other WorkBook
Excel Graph creation with UiPath
Copy one sheet to another workbook with same format
Excel link break
Convert column to number, without open the excel file
Excel link break
Adding and renaming excel sheet in a workbook
Create new excel
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
Get the wrong sheet name when reading and writing the data in the New excel workbook
Problem with Password Protected Excel file
Paste Clipboard: Exception from HRESULT: 0x800A03EC
Change Excel column to Number format & how to remove warning in cells
Excelで指定したシートを削除したい
Add comment to an excel cell
How to write excel column value as Integer?
I want to change a cell's format from generic to date
Balareva.excel.copy to workbook Error
Can we create bar graphs and charts from excel data in UiPath?
Clean a sheet from excel file
Send Hotkey in Excel Scope throws System.AggregateException
Who can i screenshoot a image from web and paste it directly in Excel?
How to AutoFit All Columns in Excel
How to get Row and Colum index separately when searching a value in excel
Delete Sheet
How to copy data from one excel workbook to another excel workbook
Get sheet name and info without using Excel application scope
How to remove duplicates entries from Row and it should remove that entire Column
Rename sheets in excel
Add password to Excel file
Copy and Paste table from excel to notepad
Need to copy few cells in Excel then past the same in notepad
Copying a whole row of one excel sheet and paste it in other sheet
Email body to excel
BalaReva.Excel.Activities Continue
Select excel column in excel
Copy pasting multiple images in excel
Piechart from excel without macros
Copying one whole row of a Data Table
How to unhide sheets present in the excel and Hide back the same sheet
Remove Duplicates from Excel

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

5 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

5 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

5 Likes

Thank you @Andreea_Stroe

3 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

3 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

3 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

2 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

3 Likes

Hi @Andreea_Stroe,

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

Regards
Balamurugan.S

3 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

2 Likes

Hi Balamurugan,

The reference number for the ticket is GSD - 115.

Best Regards,

1 Like

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

5 Likes

Here I have attached the Video for File Copy Activity

Regards
Balamurugan.S

3 Likes

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


Regards
Balamurugan.S
3 Likes

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

ExcelFindReplace.zip (18.5 KB)

Regards
Balamurugan.S

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

2 Likes

Hi @Kartika,

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

Regards
Balamurugan.S

4 Likes

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

1 Like

I understand your problem …

3 Likes