Deleting cell values - Error: Input string was not in a correct format

[ddpadil (Dilip)]

Ho,
Use read range activity to read the spread sheet existent rows. The output is a datatable.

You can use “for each row” to iterate your datatable rows.

To get first 1st column value use row(0) for second column row(1) and so on.

To check if column is empty check row(0) = Nothing in if condition.

How to check null condition

Hi, “IsNothing()” or “=Nothing” is only going to work if there’s nothing assigned to that variable but looks like in your case that an actual row is there but it just contains “” values. You could just see if certain values or columns has nothing in it like row(0)=“”, and that would tell you there’s nothing there. Or you could look at query functions such as the .Select() which you can filter out the empty rows or whatever you need.