balupad14
(Balamurugan)
December 16, 2019, 12:47pm
36
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
balupad14
(Balamurugan)
December 20, 2019, 12:32pm
38
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
1 Like
balupad14
(Balamurugan)
December 22, 2019, 12:05am
39
Hi all,
I have developed new activities called “Get Hidden Columns” and “Get Hidden Rows” version 10.0.0.
Regards
Balamurugan.S
2 Likes
balupad14
(Balamurugan)
January 1, 2020, 4:47pm
40
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
1 Like
balupad14
(Balamurugan)
January 9, 2020, 9:54pm
41
Hi All,
I have developed a new activity called " Is Merged Cell". It returns the true or false.
Thank you
Balamurugan.S
1 Like
balupad14
(Balamurugan)
January 17, 2020, 10:37am
42
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
2 Likes
kuppu_samy
(Kuppusamy)
February 11, 2020, 11:23am
44
Hi @balupad14 ,
Do you have any options to insert a file hyperlink?
like in MS Excel we have an option to do that!
3 Likes
m.Dip
(Maurizio)
February 12, 2020, 4:36pm
45
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
balupad14
(Balamurugan)
February 14, 2020, 3:02pm
46
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
balupad14
(Balamurugan)
February 22, 2020, 2:47pm
48
Hi ,
Please use the scope activity form balareva Easy Excel which have marked in the below
Regards
Balamurugan.S
1 Like
balupad14
(Balamurugan)
March 31, 2020, 7:45pm
49
Hi ,
I have included new activities called Freeze / UnFreeze Columns and Freeze / UnFreeze Rows in the version (17.0.0).
Thank you
Balamurugan.S
1 Like
sspi1153
(Slavisa)
April 1, 2020, 6:16am
50
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)
2 Likes
balupad14
(Balamurugan)
April 1, 2020, 11:24am
51
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
2 Likes
sspi1153
(Slavisa)
April 6, 2020, 3:48pm
52
Thanks a lot! Not sure what it did´t work at first place, but thanks!
2 Likes
sspi1153
(Slavisa)
April 14, 2020, 11:04am
53
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
balupad14
(Balamurugan)
April 14, 2020, 11:18am
54
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