Getting Data from Excel Sheet using ADO.NET w/o Header in first row

Question

Is there a way retrieving Data from an Excel-Sheet using ADO.net and header names when the headers are not on row one?

e.g.

[1: |BLANK | BLANK | BLANK   | ] < Blank row
[2: |Name  | Age   | Address | ] < Header row
[3: |John  | Smith | Abstr.  | ] < Data row

Isn't there a possibility to specify a "starting cell" ? e.g.

Range A9:EndOfFile

And would this trick resolve my problem?

Could you not pull the data as a recordset and query it with a SELECT statement where the record is not null? Admittedly my understanding of ADO is VERY basic, but I'm sure it's designed to be used with actuall data tables, which shouldn't have any blank rows. Can you not change the layout of the workbook? — SierraOscar
– SierraOscar, Commented Dec 2, 2014 at 14:34
ty for the comment - no, unfortunately I can not change the layout. Blank rows were just for explaining my problem, the original file I want to retrieve got some text above the actual data ( e.g. descriptions in connected cells) — Th1sD0t
– Th1sD0t, Commented Dec 2, 2014 at 14:40

Jason Hischier · Accepted Answer · 2014-12-02 14:43:02Z

1

Perhaps you could import the dataset from Excel as if it did not have a header row, then extract the data from the desired row and use programmatically set the headers for your DataTable from that data. For the ConnectionString, you can set HDR=NO to read every row as data.

Here's a link related to Excel ConnectionStrings and the HDR setting: https://www.connectionstrings.com/excel/

answered Dec 2, 2014 at 14:43

Jason Hischier

1305 bronze badges

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

Collectives™ on Stack Overflow

Getting Data from Excel Sheet using ADO.NET w/o Header in first row

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