Hi frnds.
i'm reading data from excel using vb.net application , end of excel sheet having empty rows
how to remove Empty rows while write data to dataset..
Thanks ..
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Lacy MichellePosted Aug 30, 2012, 9:26 PM
//delete the second row from sheet
sheet.DeleteRow(2);
//delete the seventh and eighth rows from sheet
sheet.DeleteRow(7,2);
See details:Excel Page Setup for C#, VB.NET