Ignore rows uipath

[Aluneth_X]

Hello guys, so this is my .xlsx file

do u know how to ignore the empty column?

the output should be

since there is empty column it throws error

here is my workflowTestOCR.zip (27.6 KB)

[vickydas (vicky)]

Hello @Aluneth_X
You can use this Query in an assign activity it’ll remove all the blank rows
(From row in DT.Rows.Cast(of DataRow) where (row.ItemArray.All(Function(r) Not (r is "" )))).CopyToDataTable

Check this workflow for better understanding
Blank.xaml (10.0 KB)

[Petar_Soce]

After read range you can just put Filter Datatable Actvitiy and filter out empty rows.