How to get empty rows from the excel

[Taruna_Gupta]

How to get empty rows from the excel in Ui Path Studio can someone help me on this. Not able to understand

[supermanPunch (Arpan)]

@Taruna_Gupta

How to get empty rows from the excel in Ui Path Studio can someone help me on this

Hi @Taruna_Gupta ,

Could you let us know what is the End Output required ? Is it only fetching the Empty rows ? Or do you want to perform additional operation after ?

This understanding would help to get us the details in one go, so we can provide better suggestions.

[mkankatala (Mahesh Kankatala)]

Hi @Taruna_Gupta

Check the below thread for better understanding

Check empty cells in Excel rows

Hello, How can I check for empty cells in an excel sheet that does not have the usual Table format? I have an excel file that instead of columns it comes in a “row format”, being the first column the names of each row. I need to identify the empty cells (Cells C7 and E8) in rows 6 to 9. How can this be done? What should be the logic behind if it is not a table format? output.xlsx (8.5 KB) Thank you in advance!

Hope it helps!!

[Shiva_Nikhil]

Hi @Taruna_Gupta

Refer the below code to the empty row from the Data Table
DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) row.ItemArray.All(Function(a) a.Equals(“”))).CopyToDataTable()

Hoep this helps

[Shiva_Nikhil]

Hi @Taruna_Gupta

you can try this

Hope this helps

[postwick (Paul Ostwick)]

What do you mean “get empty rows?” Are you trying to find the first row that has no data? Remove all the completely empty rows? You have to tell us in detail what you’re trying to do.