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

[DEATHFISH]

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?

[Sasi.lalo (Sasikumar)]

Hi @DEATHFISH,

Kindly refer the below link:

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Regards,
Sasikumar K

[DEATHFISH]

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?

[srdjan.suc]

Maybe you can use If statement like this :

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

And then do your logic

[Sasi.lalo (Sasikumar)]

Hi @DEATHFISH,

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

Regards,
Sasikumar K

[DEATHFISH]

@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

[DEATHFISH]

@srdjan.suc

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

[srdjan.suc]

Check this thread, it helped me

Check if dataRow[] is null

Hi everyone, I am still very new to UiStudio. I have an issue of checking whether the dataRow is empty. I would like to check if it’s null. I read through all of the other issues but none of them seem to be working for me… It’s an if condition to check if the dataRow variable is null.

[DEATHFISH]

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

[Sasi.lalo (Sasikumar)]

Hi @DEATHFISH,

Try this: in IF condition:

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

Regards,
Sasikumar K