Giving 0 to empty cells in Excell

Hi ,
I want to give a value of 0 to cells that are empty in Excell. But I couldn’t make it through uipath. Can you help me.
Thank you.

1 Like

Hai @Tolga_Abi Use Excel application Scope… Use if activity like cell==null then use assign activity to provide value =0
Let me know it’s working or not

Regards Nandhu.

1 Like

Thank you @Nandhuba
can you please provide xaml of how to do scenario 1?

Hi
Here you go with an xaml

Cheers @Tolga_AbiBlankProcess15.zip (16.4 KB)

1 Like

Thanks @Palaniyappan

The version looks different, do I need to install the old version.
My version 2019 10.4

image

Yah go ahead
Cheers @Tolga_Abi

1 Like

Thanks I will check. @Palaniyappan

1 Like

Great
@Tolga_Abi

@Palaniyappan
The process has happened, but how can we remove two features. First, there should be no green arrow with 0. Second, let’s not create a column at the top line. How can we do that. Thank you.
image

FIne
if we have the headers ready then enable ADD HEADERS property in the WRITE RANGE activity
and to remove green arrow make sure that those cells in those columns are not set with TEXT type in EXCEL, and it has to be checked in excel

Cheers @Tolga_Abi

1 Like

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