UiPath Go ! BalaReva EasyExcel Activities

Hello! Can you help me, please?
When i ty Extract Hyperlink from range M3:M2000 i get a error: “Extract HyperLinks: Bad Index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))”
What can I do to avoid this error?
Thanks.

1 Like

Hi @Foertsch,

Thank you for you valuable feedback.I had chance to test in various type.Yes it has bug. I have fixed it. you get he package here Version 7.1.0 .

Here i have attached sample for your. But the package is configure in local so. after open the project , configure the package from your local.

Foertsch.zip (47.0 KB)

Thank you
Balamurugan.S

3 Likes

Thanks, it’s works!
Can i ask one question, please… about VBA (hyperlink extractor).
Some links contain a " #" character, and when you try to extract a hyperlink from such a link, only the text before the “#” character displayed. For example, if i try exctract hyperlink from a link "htttp:\example.link.com#com\exampletextetc: i extract only “htttp:\example.link.com”.
Maybe you know how to solve this problem, or tell me which direction to go (I understand this is a feature of Excel, but is it possible to fix it?).
Big Thanks.

1 Like

Hi @Foertsch,

you can get the hyperlink like below.

Split(strValue,"#com")(0)

Regards
Balamurugan.S

3 Likes

I’m sorry, I made a mistake in writing the example link. The link looks like this: “htttp:\example.link.com#com\exampletextetc”. That is the sharp part of the link. Without it, link is not functional.
Up to this point, I extracted hyperlinks with using a VBA macro. I used this command in the macro: Hyperlinks(1).Address But the problem is that when extracting a link where the address contains the " # " character, only the part of the link that precedes the "# " character is extracted.
I faced with this problem when using Your activities. And I thought maybe you can tell me what to do in this situation, since links with this symbol are not extracted completely.
If you try extcract hyperlink (for example: htttp:\example.com#com\exampletext), you will see the link text exactly up to the "# " character (htttp:\example.com).
Thanks you for answer.

2 Likes

Hi @Foertsch,

Can you attach the sample xl file.

Regards
Balamurugan.S

4 Likes
htttp:\example.com\#com\exampletext
2 Likes

Sorry, the text editor cut the link itself.
OK, I will now post the file along with the excel file as an example.

1 Like

This link will not work. Becuase it has htttp instead of http. What is the output that your expecting ?

Regards
Balamurugan.S

3 Likes

I apologize again, I made a mistake again…
Here is the correct version of the link:
http:\example.com\#com\exampletext

1 Like

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.

1 Like

Hi @Foertsch,

Split(var1,"#")(0)

Design Screen.

Regards
Balamurugan.S

3 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)

1 Like

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

1 Like

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! (^▽^)ノ

1 Like

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

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

image

image

Regards
Balamurugan.S

1 Like

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