UiPath Go ! BalaReva EasyExcel Activities

Hi @Foertsch,

I understand that this is output

http:\example.com\#com\exampletext 

What is your expected output ?

Regards
Balamurugan.S

2 Likes

Full text of link.
At the moment, I only get an excerpt: "http:\example.com" this happens with all links, within there is a "#"character.

2 Likes

Hi @Foertsch,

Split(var1,“#”)(0)

Design Screen.

Regards
Balamurugan.S

4 Likes

Thank you for answer.
This " # " character is part of a hyperlink inside Excel. And when I try to extract this hyperlink from Excel, I get its incomplete address. Which doesn’t suit me. You can check this with an Excel file and a process downloaded by me. Just wanted to know if it could somehow be avoided of this or if it’s an internal feature (bug) of Excel.
textexcelactivities.zip (15.1 KB) testuipath.xlsx (8.9 KB)

2 Likes

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 キロバイト)

3 Likes

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

3 Likes

Thanks,@ balupad14

I understand! (^▽^)ノ

3 Likes

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 :
image

Line Style :

image

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

Thank you
Balamurugan.S

1 Like

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

image

image

Regards
Balamurugan.S

2 Likes

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 :
image

Remove(Delete) Hyperlink :

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

Thank you
Balamurugan.S

1 Like

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

Thank you
Balamurugan.S

1 Like

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 :
image

Out put:

image

Design Screen :slight_smile:

sample :

PradeepShiv.zip (29.8 KB)

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

Regards
Balamurugan.S

2 Likes

i’ll check thank you

2 Likes

Hi @balupad14,

Do you have any options to insert a file hyperlink?

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

image

3 Likes

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

2 Likes

Hi @kuppu_samy.

Yes you can do it like below.

OutPut…

Regards
Balamurugan.S

2 Likes

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

1 Like

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

Regards
Balamurugan.S

1 Like

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

image

Thank you
Balamurugan.S

1 Like

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. ThanksSequence14.xaml|attachment (5.2 KB) table3.xlsx (13.6 KB)

2 Likes