How to insert an icon in an excel sheet row

Hello fellow,

Here I want to insert the right tick icon ( :heavy_check_mark: ) in a particular row.

If the condition satisfied, then there should be :heavy_check_mark: to the next column of the row.

If not, then there should be :x: to the next column of the row.

This should be like this :

image

Thanks in advanced

Best Regards,
Vrushali

Hi @Vrushali_Gave

Since the tick icon (heavy_check_mark ) and cross icon (x ) 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 :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed::relaxed:

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 :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed::relaxed:

@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 :blush:

Will let you know if it works :blush:

@NIVED_NAMBIAR Okay
Thank you

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 :slightly_smiling_face:

@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 :

image

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.

:snowman_with_snow: 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…

image

Reference: Check this post

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.