Excel Read Row activity - check if blank/no data returned (ReFramework)

Hi, I am using REFramework. The workflow reads rows one by one from an Excel sheet using Read Row based on the transaction number. However when there is a blank row I want it to return Nothing to stop the workflow.

How do I check this condition - to check if the row is blank or no data returned?

Hi @DEATHFISH,

Kindly refer the below link:

Regards,
Sasikumar K

Hi, I am using REFramework and reading data rows one by one. Not using DataTable, only DataRows. So I can only detect an empty row after the transaction counter increments and shifts down. How do I do this?

Maybe you can use If statement like this :

IF DataRow(“ColumnName”).ToString <> Nothing then

And then do your logic

Hi @DEATHFISH,

Apply this before moving to Transaction process, so you will have values for all the rows.

Regards,
Sasikumar K

@Sasi.lalo

Hi, the reason for not using DataTables is because for some previous versions of UiPath the workflow will hang due to RAM restrictions when processing large volume data

@srdjan.suc

How do I do this in bulk to check if the entire row is empty? Preferably without looping

Check this thread, it helped me

I don’t really understand this thread, is it asking about processing a DataTable as an array of DataRows?

What I would like to find out is

  • I am using Read Data Row. This returns an iEnumerable
  • Check within this iEnumerable for whether Read Data Row has scanned an empty row

Hi @DEATHFISH,

Try this: in IF condition:

Not row.ItemArray.All(Function(field) field Is DBNull.Value or field.Equals(""))

Regards,
Sasikumar K