UiPathGo - BalaReva Excel Activities

Hi @balupad14,

As per activities excel output properties pdf format is default type.

how can i change as per user input ? some time user required in xps format

user have two input option
a)PDF
b)XPS

If user give XPS as input in run time bot have to select excel output and the format type as XPS file format.

Note : user input given in excel file.

Regards,
Balasubramanian.

Hi,
In the version 2019.9.3, I have included a new property that to extract the selected range cells as pdf file.

Note :
If the cell range is blank, It will export the worksheet as pdf.
The package has been attached in the beginning of the thread.

Regards
Balamurugan.S

Hi , i am new in UiPath. can somebody help me if activity from balareva is safe to use in production environment? (in terms of stability and support)

thanks

1 Like

Hi @tommyh,

This is BalaReva. My packages are developed by c#.Net. It never harm the environment of the system. It is so safe.

Thank you
Balamurugan.S

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