UiPathGo - BalaReva Excel Activities

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

Sample Project :
ExcelRemoveDuplicate.zip (31.0 KB)

Thank you
Balamurugan.S

1 Like

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

Thank you
Balamurugan.S

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

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

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

Thank you
Balamurugan.S

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! Capture

1 Like

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

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:
image

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

Hoping you can help me!

Hi @eduardo.melchor,

Welcome to UiPath Community !

Can you share the workflow with sample file please.

Thank you
Balamurugan.S

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.

1 Like

HI @eduardo.melchor,

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

Thank you
Balamurugan.S

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.

1 Like

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.

or

Thank you
Balamurugan.S

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

Thanks in advance

1 Like

I hope yes…

Thank you
Balamurugan.S

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 ?

Sample : 20_HideUnhideColRow.zip (31.2 KB)

Thank you
Balamurugan.S

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

image

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

Hi @jerzy.sorokowski,

Can you share sample workflow with excel file ?

Thank you
Balamurugan.S

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

1 Like

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