How to to check Excel sheet column-name row using ExcelDataReader?

Asked Jul 31 '15 at 17:59

Active Jul 31 '15 at 19:04

Viewed 492 times

Assume I have an Excel work sheet with first row that must be column names:

FirstName  LastName   DepartmentId     <-- first row is column names
john       doe         1
jane       doe         2
...

I have 2 questions:
- How can I check if the first row is column names by requirement of the work sheet?
- If the first row is column names, how can I check those column names match predefined names such as FirstName, LastName, and DepartmentId?

edited Jul 31 '15 at 19:04

bakoyaro

2,550
3
36
63

asked Jul 31 '15 at 17:59

Thomas.Benz

8,381
9
38
65

the exceldatareader should have a IsFirstRowAsColumnNames property that is a boolean value. – Sorceri Jul 31 '15 at 19:11
This is to late to comment here! But which language are you using C#, Java, VB.Net , ... ? – shA.t May 15 '19 at 10:01

How to to check Excel sheet column-name row using ExcelDataReader?

0 Answers0