For Each- Row Indexs: Object reference not set to an instance of an object

Hello there,
can anyone help, please? I am getting this error when running my BOT. I find the row index of particular value in excel file.
Using row index delete row where value is found.

try this solution

Sequence.xaml (10.1 KB)

1 Like

Thanks, I don’t know column number and column number is not fix it’s change dynamically. I know only particular value.

as per i understood,are you need to check the particular value in all columns and if exist you need to delete the row?

Yes, Find value in all columns and delete this row.

ok you can try this

Sequence.xaml (11.3 KB)

Hey!

Use Lookup data table to get the particular value or index

OR

Try this

Dt.Select("[ColumnName]='Value'").CopyToDataTable

Regards,
NaNi

Thanks It’s working

Thanks for reply
Column Name/Column number is not fix It’s change dynamically.

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