UiPathGo - BalaReva Excel Activities

I understand your problem …

4 Likes

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

4 Likes

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

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

4 Likes

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

you can get the package like below in the studio.

The activities are :

image

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

4 Likes

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

3 Likes

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.

Regards
Balamurugan.S

7 Likes

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

4 Likes

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”.

3 Likes

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

4 Likes

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

2 Likes

Hi @balupad14

I am getting below error in column chart activity

can you pls help to resolve error.

Regards,
Balasubramanian.

2 Likes

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

2 Likes

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

1 Like

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