Excel problem write cell

Help Studio
, ,
1

I have a query, i want to loop through each cell of column C in excel sheet and if there is any cell is empty in column C then write 0 into it.

2

Hi @Satyam_Shrivastava

Use Find/Replace activity

image
image900×960 42.5 KB

image
image1512×722 42.9 KB

Input:

image

Output:

image

Regards,

3

Hi @Satyam_Shrivastava
in if condition

String.IsNullOrEmpty(CurrentRow("Period").ToString)

image
image688×685 28 KB

4

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