UiPathGo - BalaReva Excel Activities

[balupad14 (Balamurugan)]

Hi ,
Here I have attached a video demonstration for Remove duplicate rows in Excel .

Sample Project :
ExcelRemoveDuplicate.zip (31.0 KB)

How to remove duplicate rows in Excel using UiPath (remove duplicates)

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi ,

I have uploaded a video that to change the cell or column format in excel using UiPath…
The activity is having the below functionality

UiPath | How to change the cell or column format in Excel | Guide (datatype)

Thank you
Balamurugan.S

[salvatore.quimi]

Hi… I don’t know if my question has already been asked in another post but I downloaded the “BalaReva.DataTable.Activities” but when I use the “CountActivity” then it gives me the following error: " Syntax error in aggregate argument: Expecting a single column argument with possible ‘Child’ qualifier"
Ps I have Uipath version 18.4.5
Best Regards,
Salvo

[balupad14 (Balamurugan)]

Hi,
Welcome to UiPath Community !. I think , may be the datatype is not native (possibly is object data type). Can you send me a sample and test at my side . and i will send you changes…

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi,
Here I have attached a video that I have demonstrated the Extract Graph as Image .

UiPath excel Extract Graph as Image | find last column Index| find last Row No...

Thank you
Balamurugan.S

[Aldo_Mo]

Hi balupad14,
thanks a lot for your amazing package.
I have a simple question, how could I set the range of the column? Since it tells me that I have to declare the column as variable, I would like to know if it can be done differently
Thanks in advance,
Aldo!

[balupad14 (Balamurugan)]

Hi @Aldo_Mo,

Welcome to Uipath Community !

To set Range column like A to E . you have to give {“A:E”} like this.

Thank you
Balamurugan.S

[eduardo.melchor]

Hi, I having troubles with one of the excel activities, I’m trying to remove duplicates rows, the activity runs with no problems but doesn’t do anything.

This is how the activity is configured:

I need to remove the duplicates from colum A or {1} and just leave the first one.

Hoping you can help me!

[balupad14 (Balamurugan)]

Hi @eduardo.melchor,

Welcome to UiPath Community !

Can you share the workflow with sample file please.

Thank you
Balamurugan.S

[eduardo.melchor]

Hi @balupad14,

Thank you for your answer, I figured out, I was using the activity inside of a Excel Scope Activity, when I used it outside works perfectly in the background, however I’d like to know if there is a way to don’t save automatically the file.

[balupad14 (Balamurugan)]

HI @eduardo.melchor,

Well. My all activities are by default auto save functionality…

Thank you
Balamurugan.S

[Peter_Carnogursky (Peter Čarnogurský)]

Hi there,

I´d like to ask whether there is an option to export to .pdf only one and selected sheet, not all of them. Otherwise very helpful dependency.

Many thanks in advance.

[balupad14 (Balamurugan)]

Hi @Peter_Carnogursky,

Welcome to UiPath community !
Already I have provide this option in my latest package. I am publishing the package in UiPath Marketplace.

But you can get it here.

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 …

or

BalaReva – Make easy the automation

Thank you
Balamurugan.S

[salvatore.quimi]

@balupad14

BalaReva.Excel.Activities

Hi @balupad14 i would know if the BalaReva.Excel.Activities is support to Uipath 18.4.5 version.

Thanks in advance

[balupad14 (Balamurugan)]

I hope yes…

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi All,
Here is the video demonstrator for

• How to hide and unhide the column in excel ?
• How to hide and unhide the rows in excel ?

UiPath Excel Hide and Unhide Activity (BalaReva)

Sample : 20_HideUnhideColRow.zip (31.2 KB)

Thank you
Balamurugan.S

[jerzy.sorokowski]

Hi, I have problem with activity “Format Cells” when I want to set vertical alignment of cell(s) to “Top”:

I get error message:
“Format Cells: Unable to set the HorizontalAlignment property of the Range class”
But I do not set Horizontal Alignment at all (I leave “Horizontal” field as “Select”)
When I set “Verticle” to “Center”, I get centered horizontal alignemnt, not vertical one.

Thanks in advance for help
Jerzy
P.S. I got this error for version 2019.10.1 as well for 2020.0.1. I’m using Studio Pro 2020.6.0-beta.93

[balupad14 (Balamurugan)]

Hi @jerzy.sorokowski,

Can you share sample workflow with excel file ?

Thank you
Balamurugan.S

[jerzy.sorokowski]

The workflow:

Formatowanie Raportu.xaml (27.1 KB)

Excel File:

20200707_PodsumowaniePrzebieguTestu.xlsx (10.2 KB)

You should change default value of variable summaryReportFileName to point attached Excel file.

BR
Jerzy

[balupad14 (Balamurugan)]

I will take a look. and get back to you…