public void Test_Import()
{
var result = _excelImportProvider.Convert <Barcode>("D:\\导入国标码_导入格式.xlsx");
foreach (var sheet in result.Sheets)
{
foreach (var header in sheet.GetHeader())
{
Output.WriteLine(header.Cells.Select(x => x.Value.ToString()).Join());
}
foreach (var body in sheet.GetBody())
{
Output.WriteLine(body.Cells.Select(x => x.Value.ToString()).Join());
}
}
}
private ExcelData GetExcelData <T>(ImportOption importOption)
where T : class, new()
{
return(_excelImportProvider.Convert <T>(
importOption.FileUrl
, importOption.SheetIndex
, importOption.HeaderRowIndex
, importOption.DataRowStartIndex));
}
