UiPathGo - BalaReva Excel Activities

[balupad14 (Balamurugan)]

Hi @Kartika,

Here I have attached the Project zip along with output.xlsx.

Karthika.zip (27.9 KB)

Note :

If you have any doubts let me with tomorrow.

Regards
Balamurugan.S

[igorpicoli]

Thanks man, it really has saved me today!!!

I spent more than three hours trying to do it on excel!

[balupad14 (Balamurugan)]

Hi,
Here is the information about the Autofit column and row…

you can get the package like below in the studio.

The activities are :

Properties

Here you have an option to specify the Column Width instead of AutoFit

Here you have an option to specify the Row Height instead of AutoFit

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi All,

I have done a major changes in the BalaReva.Excel.Activities that allows the property value empty to Sheet Name and Cell Range.

If the sheet name is empty , It will take the first sheet name automatically.
If the Cell range is empty , It will the used range.

I have attached the package in the first thread.

I have tagged a user @VanessaCova …

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi,
I have included a new activity called “Export WorkBook”. Using this activity that can able to export the workbook as PDF and XPS.

Name Space :

Activity and Properties :

Note :

Let me if you have any errors.
I would be happy to get more suggestions and feedback (Possibly likes).

Here is the video demonstration also.

Excel - How to export the excel to pdf, xps

Hi, I have uploaded a video that how to export excel to pdf and XPS. [UiPath Excel export to PDF , XPS] More details : Excel export to PDF, XPS – BalaReva Here is the sample: ExportToPdf.zip - Google Drive Regards Balamurugan.S

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

Hi,
I have developed a new activity called “Extract Graph Image” to extract the all the graphs as a images. It has the option to extract various format (bmp,gif,jpg,png)

Namespace :

Activity and Properties :

Note :

Let me if you have any errors.
I would be happy to get more suggestions and feedback (Possibly likes ).

Regards
Balamurugan.S

[syedaquib77 (Syed Aquib)]

Hello @balupad14

Thank you so much for your project on the package, it has helped a lot.

But could you please tell me on how to copy different range to clipboard eg: “E1:E29,H1:I29”?

Currently if I enter the above range its copying the complete range from “E1:I29”.

[balupad14 (Balamurugan)]

Hi @syedaquib77
Welcome to you UiPath Forum Community !

Can not copy multiple range at a time. You can copy multiple range one by one or like below.

Sample : syedaquib77.zip (19.8 KB)

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

Hi all,
An additional information about the new activity called FormatCells . It has all feature like align the text.

Screen Design :

Sample : FormatCell.zip (30.3 KB)

Regards
Balamurugan.S

[BALASUBRAMANIAN]

Hi @balupad14

I am getting below error in column chart activity

can you pls help to resolve error.

Regards,
Balasubramanian.

[BALASUBRAMANIAN]

Hi @balupad14,

Is format type can change according to user input ???

User Input will be enter in excel sheet .

Ex:

User abc want export in pdf file format and user xyz want export in xps file format.

Regards,
Balasubramanian

[balupad14 (Balamurugan)]

@BALASUBRAMANIAN

I am getting below error in column chart activity

can you pls help to resolve error.

Hi @BALASUBRAMANIAN,

Welcome to UiPath Community !

Can you send me a sample file or real one. Because each user is having different way maintaining the data. If i get the file , It is easy to me to give the solution…

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

@BALASUBRAMANIAN

Is format type can change according to user input ???

User Input will be enter in excel sheet .

Ex:

User abc want export in pdf file format and user xyz want export in xps file format.

Regards,
Balasubramanian

You can do it.

use the Export Workbook Activity

UiPathGo - BalaReva Excel Activities

Hi, I have included a new activity called “Export WorkBook”. Using this activity that can able to export the workbook as PDF and XPS. Name Space : [image] Activity and Properties : [image] Note : Let me if you have any errors. I would be happy to get more suggestions and feedback (Possibly likes). Here is the video demonstration also. Regards Balamurugan.S

Thank you
Balamurugan.S

[BALASUBRAMANIAN]

Hi @balupad14

PFA xaml file and sample file for your reference.

Regards,
BalasubramanianGraph.zip (155.4 KB)

[balupad14 (Balamurugan)]

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

[BALASUBRAMANIAN]

Hi @balupad14,

Thank you so much for your help error resolved.

Regards,
Balasubramanian

[BALASUBRAMANIAN]

@balupad14

Export WorkBook

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.

[balupad14 (Balamurugan)]

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

[tommyh (ToM)]

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

[balupad14 (Balamurugan)]

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