How to detect an empty column in excel?

[vivek_Chowdary]

I have a scenario where there’s an excel file in which there is some data which is being scraped from the web. If a particular row contains ‘Null’ data for any specified column, then I want it to take 0. How can I achieve this task in UiPath?

[jothyprasanth.m (JothyPrasanth)]

@vivek_Chowdary

‘Null’

You can use row(“ColumnName”).ToString.Equals(String.Empty) this will return Boolean Value.

[vivek_Chowdary]

@jothyprasanth.m
Its not working out. The problem is, I have to add one field with another after assigning it a value. There I am getting a type error. I don’t understand why.

[pavanh003 (Pavan Harisha)]

Hi,
Please try this and let us know if this helps.
inside for each if row.item(“ColumnName”).tostring.length=0 then add zero in that place or you can try like this as well

DT.AsEnumerable().Where(Function(r) r.ItemArray.Any(Function(a) string.IsNullOrEmpty(a.ToString))).Count>0.

Let us know if this helps.

Regards,
Pavan H

[sreekanth]

Refer this @vivek_Chowdary,

Check which excel field is empty for imputing data

You can do this check on a Loop (For Each Row activity). With in that foreach, you will need an "If " activity to check: row.item(“ColumnName”).ToString() = “” or row.item(“ColumnName”) = nothing If match found, assign the value in to that cell using Assign activity.