public ExcelData ReadExcel(string path) { var time = DateTime.Now; ExcelData res = new ExcelData(); res.DataList = new List <ExcelTable>(); string strConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + path + ";Extended Properties='Excel 12.0; HDR=NO; IMEX=1'"; var sheets = GetExcelSheetName(strConn); foreach (var sheetName in sheets) { ExcelTable tmpTable = new ExcelTable(); tmpTable.Data = ReadSheet(strConn, sheetName); res.DataList.Add(tmpTable); } var space = DateTime.Now - time; Console.WriteLine("cost time " + space.TotalMilliseconds); LogQueue.Instance.Enqueue("DB reader cost time " + space.TotalMilliseconds); return(res); }
public ExcelData ReadExcel(string path) { var time = DateTime.Now; ExcelData res = new ExcelData(); res.DataList = new List <ExcelTable>(); string filePath = path; FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read); IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); var result = excelReader.AsDataSet(); for (int i = 0; i < result.Tables.Count; ++i) { int rowCount = result.Tables[i].Rows.Count; int colCount = result.Tables[i].Columns.Count; ExcelTable table = ReadSheet(rowCount, colCount, result.Tables[i]); res.DataList.Add(table); } excelReader.Close(); stream.Close(); var space = DateTime.Now - time; Console.WriteLine("cost time " + space.TotalMilliseconds); LogQueue.Instance.Enqueue("ER reader cost time " + space.TotalMilliseconds); return(res); }
public override ExcelData ReadExcel(string path) { var time = DateTime.Now; ExcelData res = new ExcelData(); res.DataList = new List<ExcelTable>(); string filePath = path; FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read); IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); var result = excelReader.AsDataSet(); for (int i = 0; i < result.Tables.Count; ++i) { int rowCount = result.Tables[i].Rows.Count; int colCount = result.Tables[i].Columns.Count; ExcelTable table = ReadSheet(rowCount, colCount, result.Tables[i]); res.DataList.Add(table); } excelReader.Close(); stream.Close(); var space = DateTime.Now - time; Console.WriteLine("cost time " + space.TotalMilliseconds); LogQueue.Instance.Enqueue("ER reader cost time " + space.TotalMilliseconds); return res; }
public override ExcelData ReadExcel(string path) { var time = DateTime.Now; ExcelData res = new ExcelData(); res.DataList = new List<ExcelTable>(); string strConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + path + ";Extended Properties='Excel 12.0; HDR=NO; IMEX=1'"; var sheets = GetExcelSheetName(strConn); foreach (var sheetName in sheets) { ExcelTable tmpTable = new ExcelTable(); tmpTable.Data = ReadSheet(strConn, sheetName); res.DataList.Add(tmpTable); } var space = DateTime.Now - time; Console.WriteLine("cost time " + space.TotalMilliseconds); LogQueue.Instance.Enqueue("DB reader cost time " + space.TotalMilliseconds); return res; }
protected override void ImporteExcel(ExcelData data, out ImporterPkg outPkg, ref string errMsg) { outPkg = null; }
protected abstract void ImporteExcel(ExcelData data, out ImporterPkg outPkg, ref string errMsg);