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);
