UiPath Go ! BalaReva EasyExcel Activities

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

Hi @jayant.nandamudi,

To search and find out the cell information , you can use search activity in the below.

Thank you
Balamurugan.S

1 Like

@balupad14
Hello.
Using Move sheet Activity,
What do I have to do to move the sheet to the last?
Move to end…

Regards.

2 Likes

@balupad14 hi had posted query can you see if you can help?? I tried the Get Hyperlink activity but it didn’t worked.

1 Like

Hi @ssong,

I have update the new version(19.1.0) in the beginning of the thread . you can download it and use it.

I did the change in the Move Sheet activity to move the sheet first and last position.
In the Initial Sheet name property you can use below thing with function
“:First” - Move sheet in the first position
“:Last” - Move sheet in the last position

Note :
It is case sensitive.

Thank you
Balamurugan.S

2 Likes

@balupad14
Thank you so much.
Your program is very perfect.
Regards.

2 Likes