.NET xlReader for Microsoft Excel connection strings

cslist_top_horizontal

Excel 97

Excel file with header row (for versions 97 - 2003)

Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;

Excel file without header row (for versions 97 - 2003)

Data Source =c:\myExcelFile.xls;HDR=no;Format=xls;

Excel 2000

Excel file with header row (for versions 97 - 2003)

Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;

Excel file without header row (for versions 97 - 2003)

Data Source =c:\myExcelFile.xls;HDR=no;Format=xls;

Excel 2002

Excel file with header row (for versions 97 - 2003)

Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;

Excel file without header row (for versions 97 - 2003)

Data Source =c:\myExcelFile.xls;HDR=no;Format=xls;

Excel 2003

Excel file with header row (for versions 97 - 2003)

Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;

Excel file without header row (for versions 97 - 2003)

Data Source =c:\myExcelFile.xls;HDR=no;Format=xls;

Excel 2007

Excel file with header row

Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;

Excel file without header row

Data Source =c:\myExcelFile.xlsx;HDR=no;Format=xlsx;

Excel 2010

Excel file with header row

Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;

Excel file without header row

Data Source =c:\myExcelFile.xlsx;HDR=no;Format=xlsx;

Excel 2013

Excel file with header row

Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;

Excel file without header row

Data Source =c:\myExcelFile.xlsx;HDR=no;Format=xlsx;