UiPath Go ! BalaReva EasyExcel Activities

[ryoko]

Hi, @balupad14

I tried to use it, but I got an error.
”Find & Replace: Object reference not set to an instance of an object.”
How should I set the properties?

Excel_Find_and_Replace.zip (27.3 キロバイト)

[balupad14 (Balamurugan)]

Hi @ryoko,

Thank you for using the package.
I saw you attachment

The activity can work only inside BalaReva Excel Scope. Don’t use it inside the UiPath Excel Scope activity.

Like below

I have change sample that I have attached it here.

Excel_Find_and_Replace.zip (24.2 KB)

Thank you
Balamurugan.S

[ryoko]

Thanks,@ balupad14

I understand! (^▽^)ノ

[balupad14 (Balamurugan)]

Hi,
I have developed a new activity to set the border to the range or cell inside the workbook.

Properties :

Detail of the properties
Presets :

Line Style :

Border Color :
You can set the color like .“Color.Red”.
Border weight :
you can specify the border weight like 4.

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi all,
I have developed new activities called “Get Hidden Columns” and “Get Hidden Rows” version 10.0.0.

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

Hi ,
I have developed new activities called “Insert Hyperlink”, “Get Hyperlink” and “Remove Hyperlink”.

Insert Hyperlink - Add hyperlink (display text and address) to the cell .
Get Hyperlink - Get the address for the hyperlinked cell.
Remove Hyperlink - Remove the hyperlink the the cell (It won’t delete display text)

Insert Hyperlink :

Get Hyperlink :

Remove(Delete) Hyperlink :

Note :
Special thanks to @Gnaneshwari_Pinna . She gave the idea made these activities.

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi All,
I have developed a new activity called " Is Merged Cell". It returns the true or false.

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi ,
One of my friend from Linked (Pradeep Shiv) has asked question that

i’ve to delete in between rows based on start and end keyword for example if my row(0) start with ABC starts deleting till it finds XYZ …

Here the solution .

• Download the package from the begin of the thread(Version 16.0.0).

Data Sample :

Out put:

Design Screen

sample :

PradeepShiv.zip (29.8 KB)

The package has been configure in local . Not from UiPath Go.

Regards
Balamurugan.S

[Pradeep_Shiv]

i’ll check thank you

[kuppu_samy]

Hi @balupad14,

@balupad14

Insert Hyperlink - Add hyperlink (display text and address) to the cell .
Get Hyperlink - Get the address for the hyperlinked cell.
Remove Hyperlink - Remove the hyperlink the the cell (It won’t delete display text)

Do you have any options to insert a file hyperlink?

like in MS Excel we have an option to do that!

[m.Dip (Maurizio)]

hi there! thank you for your work!

I got here because I’m struggling with hyperlink writing in excel cells.

precisely I’d like (better, I need) to do that without excel scope activity cause my process is running on a windows server without Microsoft Office installed!

As you would know, trying to use workbook write range sadly fails when writing hyperlink of the kind “HYPERLINK(address, hypertext)”.

Have you ever faced this kind of issue? many thanks in advance, Bob

[balupad14 (Balamurugan)]

Hi @kuppu_samy.

Yes you can do it like below.

OutPut…

Regards
Balamurugan.S

[Renuka_Kalbahr (Renuka)]

I am getting error as below.
Get Hyperlink: Object reference not set to an instance of an object.
how to solve this

[balupad14 (Balamurugan)]

Hi ,
Please use the scope activity form balareva Easy Excel which have marked in the below

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

Hi ,
I have included new activities called Freeze / UnFreeze Columns and Freeze / UnFreeze Rows in the version (17.0.0).

Thank you
Balamurugan.S

[sspi1153 (Slavisa)]

@balupad14

• ystem.Drawing.Color
• Font UnderLine { None,Double,Double Accoun

Hi Balamurugan,

I am trying to use change color activity.

It is withing excel app. scope, and I just want to change font color. Therefore I am using argument:
System.Drawing.Color.Black.

I selected existing sheet and range, but still I ma getting error: “Cell Font: Obejct reference not set to an instance of an object”.

Exalpe is attached. Thanks (5.2 KB) table3.xlsx (13.6 KB)

[balupad14 (Balamurugan)]

Hi @sspi1153,

Thank you for using the package. It is working well.
Here is the output.

Here is the sample :

sspi1153.zip (24.9 KB)

/R
Balamurugan.S

[sspi1153 (Slavisa)]

Thanks a lot! Not sure what it did´t work at first place, but thanks!

[sspi1153 (Slavisa)]

Hi Balamurugan.S,

I am using your find acitivity.It works great.

But even in Excel Scope I entered password required to open the file, seems this is not working. I need to enter the passowort each and everytime manually (e.g. exel pop-up and waits for pass to be entered).

Do you have an solution for this?

Thanks and regads!

[balupad14 (Balamurugan)]

Hi @sspi1153,

I have tested here. it is working. Can you send me a sample file via message.

Thank you
Balamurugan.S