How to read mixed data type values from Excel in Asp.net?


Posted on June 22nd, 2015 by Hitesh Kumar | 498 Views

Mixed data type values can be read from excel file with the following Connection strings.
For Excel file below 2007 Version.

OleDbConnection Con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelFilePath + @"; Extended Properties=Excel8.0;IMEX=1;HDR=NO;ImportMixedTypes=Text");


For Excel file 2007 and above Version.

OleDbConnection Con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelFilePath + @"; Extended Properties=Excel12.0;IMEX=1;HDR=NO;ImportMixedTypes=Text");


IMEX=1
It means columns can have multiple datatype values.
HDR=NO
It means No header row.
ImportMixedTypes=Text
It means All mixed datatype columns will be treated as Text Type.

Related posts:

  1. Value does not fall within the expected range in excel to pdf conversion.
  2. How to convert excel to pdf in C#.
  3. Microsoft Office Excel cannot access the file ‘C:\inetpub\wwwroot\*’.
  4. Export datatable to CSV (Comma Separated Values) in Asp.net.