Skip a few rows when parsing Excel using OleDb

Question

I chose OleDb as a method of reading data from Excel, one of my problems on parsing the Excel is this:

I want to skip a few rows from the file (let's call them a header..) - there are merged cells there and other stuff I need to ignore, I found this syntax:

'SELECT * FROM [Sheet1$a4:c]',

specifying "a4" - the left corner of the header row, and "c" - the right most column where the data is ..how ever this is not OK to me as I do not know the exact number of columns with data I need to parse ...Is there another way of accomplishing this ?

Any reason why you cannot use a little code to find the bottom right cell? — Fionnuala
– Fionnuala, Commented Dec 18, 2011 at 22:15
Well...no particular reason, I checked & it works, it seems that I just read somewhere that Ole would take the first row to calculate the columns number, which seems to be incorrect .... — aly
– aly, Commented Dec 19, 2011 at 8:50

Melkor S.K · Accepted Answer · 2013-10-11 08:02:31Z

4

you can take all rows in a dataTable and then

IEnumerable<DataRow> newRows = dt.AsEnumerable().Skip(1);
DataTable  dt2 = newRows.CopyToDataTable();

dt2 now contains all rows but the first.

answered Oct 11, 2013 at 8:02

Melkor S.K

1331 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Skip a few rows when parsing Excel using OleDb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related