UiPath Go ! BalaReva EasyExcel Activities

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

Hi @sspi1153,

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

image

Here is the sample :

sspi1153.zip (24.9 KB)

/R
Balamurugan.S

2 Likes

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

2 Likes

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!

1 Like

Hi @sspi1153,

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

Thank you
Balamurugan.S

1 Like

Hi @balupad14, Thanks for the great activity created. I needed some help on actually reading the excel file column next to the item which has been searched and then use that data to pass on to my JSON.
Is it possible?
Suppose my sample excel is

And I need to use the value of Title: which is TITLE VALUE in JSON schema as below

{
“title”: title variable,
“partno”: part number variable,
“conig”: config variable
}

Can you suggest?

1 Like