Giving 0 to empty cells in Excell

Help
1

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
2

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
3

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

4

Hi
Here you go with an xaml

Cheers @Tolga_AbiBlankProcess15.zip (16.4 KB)

1 Like
5

Thanks @Palaniyappan

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

image

6

Yah go ahead
Cheers @Tolga_Abi

1 Like
7

Thanks I will check. @Palaniyappan

1 Like
8

Great
@Tolga_Abi

9

@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

10

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
11

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