Getting extra empty rows in collection from excel

[jrprajapati]

Hi guys,
I have one problem. When I read worksheets as a collection, I am getting four extra empty rows in the collection. Can anyone please let me know why is it happening?
thanks

 

[gil.silva]

Hello,

This happens because the Get Worksheet as Collection considers all the 'formated'/'visited' rows.
You have the action Remove Empty Rows which can/should be use ALWAYS, after you get a worksheet as collection.

 

[Manikanta]

Hey @jrprajapati As @gil.silva sai u can do, Otherwise delete empty rows manully and then take WS as Collection then u can't get any empty rows for u in ur result collection.