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