Excel file with header row using xlReader
Connection string
This .NET xlReader for Microsoft Excel connection string can be used for connections to Excel 2007, Excel 2010 and Excel 2013.
Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;
This .NET xlReader for Microsoft Excel connection string can be used for connections to Excel 2007, Excel 2010 and Excel 2013.
Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;