FileStream stream = File.Open(strTempPath, FileMode.Open, FileAccess.Read); if (Path.GetExtension(strTempPath).Equals(".xls")) excelReader = ExcelReaderFactory.CreateBinaryReader(stream); // Reading from a binary Excel file ('97-2003 format; *.xls) else excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); //Reading from a OpenXml Excel file (2007 format; *.xlsx) excelReader.IsFirstRowAsColumnNames = true; //DataTable tblSchema = (new BusinessFacade.CommonSystem()).GetTableSchema(strTableName); DataTable result = new DataTable(); //result = tblSchema.Clone(); result = excelReader.AsDataSet().Tables[0]; excelReader.Close(); var dateColumns = from DataColumn d in result.Columns where d.DataType == typeof(DateTime) select d.Ordinal + 1; return result;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)