Replace blank cell in column with specific word

Help Activities
, , ,
1

Hi
i have a scenario whee i have to replace blank cells in column 0.
Need to replace with word “xyz”, multiple consecutive rows and multiple times too.
data1.xlsx (9.9 KB)

TIA

2

Hi @8b6861dc5e0c9f7008548ca66

How about the following?

image
image900×964 33.1 KB

Hope this helps!!

3

Hi,

Can you try the following sample?

image
image730×1064 27.6 KB

Sample20231214-4L.zip (10.1 KB)

Regards,

4

Thanks @lrtetala will it work if rows more than 50-100, sometimes I observed we get com error if used excel scope .
pls assist on this

5

@8b6861dc5e0c9f7008548ca66

It will work

6

thanks @Yoichi - I will try this and will let you know.

7

HI @8b6861dc5e0c9f7008548ca66

Input:

image
image548×793 11 KB

Output:

image
image548×766 10.9 KB

=> Use Read Range Workbook to read the excel and store the output in data table say dt.
=> Use the below syntax in Assign activity:

dtUpdated= dt.Clone()

dtUpdated= (From row In dt.AsEnumerable()
     Let updatedValueCol0 = If(String.IsNullOrWhiteSpace(row(0).ToString()), "xyz", row(0).ToString())
     Let originalValueCol1 = row(1).ToString()
     Select dtUpdated.Rows.Add(updatedValueCol0, originalValueCol1)).CopyToDataTable()

=> Use Write Range Workbook to write dtUpdated data table back to excel.

image
image968×667 100 KB

Hope it helps!!

8

thanks @Parvathy - i will check