how to remove empty rows before formng as dataset

Oct 8, 2014 at 11:24 AM
Edited Oct 8, 2014 at 11:25 AM
Hi Team,

Initially i have 20 records in my excel sheet with formatted(given rows colors).when i debug the code i am getting 20 records. this is fine. but when i debug the code after deleting the 10 records from excel sheet i am still getting 20 records. 10 records coming as blank. i mean the empty records rows also coming in dataset.

now how do i remove the empty record rows. please help