Delete cell in excel with specific value

Need a help,

Is there a way to delete a cell in excel with specific value.
i want to make the cell empty wherever the value is “0”
image * Number * Number
0 2953
0 6093
0 -2250
0 3000
0 2000
0 5559
0 7000
0 1401
0 4959
0 5692
0 4660
41067 0
0 0
0 0

Yah that’s possible
—use excel application scope and pass the file path of excel as input
—inside the scope use READ RANGe Activity and get the output with a variable of type datatable named dt
—now use a for each row loop and pass the above variable dt as input
—inside the loop use IF Condition like this
row(“yourcolumnname”).ToString.Equals(“0”)
If it’s true it will go to THEN apart where we can use a simple assign activity like this
row(“yourcolumnname”) = String.Empty

Cheers @Manikandasamy

2 Likes

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