Hello fellow,
Here I want to insert the right tick icon ( ) in a particular row.
If the condition satisfied, then there should be to the next column of the row.
If not, then there should be to the next column of the row.
This should be like this :
Thanks in advanced
Best Regards,
Vrushali
Hi @Vrushali_Gave
Since the tick icon ( ) and cross icon ( ) are images
So u can use insert image at cell of balareva activity
Based on condition u can use it
Refer the activity below
UiPathGo - BalaReva Excel Activities
Hope it helps you
Regards
Nived N
Happy Automation
2 Likes
@NIVED_NAMBIAR Thank you for reply
But I’m working on enterprise edition therefore I can’t use this package
any other ways to do this ?
Hi @Vrushali_Gave
If u are not able to download the package
Then to.add the image at cell
You can use invoke code activity to invoke the vb.net code
Check the code here
insert image on excel cell
Hope it helps you
Regards
Nived N
Happy Automation
@NIVED_NAMBIAR We have an option conditional formatting ==> Icon Sets in an excel. Can you perform this task using this option ?
Let me try buddy
Will let you know if it works
@NIVED_NAMBIAR Okay
Thank you
balupad14
(Balamurugan)
January 5, 2021, 8:48am
8
Hi @NIVED_NAMBIAR thank you to refer the package.
@Vrushali_Gave , you can use it in your enterprise edition. It will work on all versions.
Thank you
Balamurugan.S
2 Likes
@balupad14 , That’s great . Thank you sir
1 Like
@NIVED_NAMBIAR Can we insert icon using formula or else shortcut key ? Any idea ?
Hi @Vrushali_Gave
I couldn’t find any formula related to that
Well u can insert the picture by using the hi Automation in excel
But better than that u can go with the balareva package or vb.net code as suggested
@NIVED_NAMBIAR Okay. Thank you
@Vrushali_Gave - Alt + 10008/10007 will add X mark … you try send this using keyboard shortcuts to see if this works…
1 Like
@prasath17
It shows like this :
jeevith
(Jeevith Hegde, Ph.D.)
January 6, 2021, 7:02am
15
Hi @Vrushali_Gave ,
This is possible.
Just look at the creative solution from @stefano_negro in the link below to add symbols/ icons using ASCII characters. As far I known office 365 also support unicode symbols as well. This solution does not require any permissions as such.
Advent Challenge #1 - News / Advent of UiPath 2020 - UiPath Community Forum
1 Like
@jeevith Sir, I tried using send hotkey activity but not woking
@Vrushali_Gave - Sorry I said ALT instead of Unichar…If you use write cell activity and send this to the cell…it will work…
Reference: Check this post
1 Like
system
(system)
Closed
January 9, 2021, 3:00pm
18
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.