UiPathGo - BalaReva Excel Activities

You can do it.

use the Export Workbook Activity

Thank you
Balamurugan.S

1 Like

Hi @balupad14

PFA xaml file and sample file for your reference.

Regards,
BalasubramanianGraph.zip (155.4 KB)

2 Likes

Hi @BALASUBRAMANIAN,

Here is the output :

I have done some changes in the package. You can use this one instead of from UiPath Go !

BalaReva.Excel.Activities.2019.8.0.nupkg (56.6 KB)

Regards
Balamurugan.S

1 Like

Hi @balupad14,

Thank you so much for your help error resolved.

Regards,
Balasubramanian

2 Likes

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.

1 Like

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

1 Like

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

2 Likes

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

1 Like

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

2 Likes

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

1 Like

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

1 Like

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

1 Like

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

Thank you
Balamurugan.S

1 Like

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

2 Likes

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

1 Like

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!

1 Like

Hi @eduardo.melchor,

Welcome to UiPath Community !

Can you share the workflow with sample file please.

Thank you
Balamurugan.S

1 Like

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.

2 Likes

HI @eduardo.melchor,

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

Thank you
Balamurugan.S

1 Like

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.

2 Likes