public void ExportCompanyEmployees(string templateFilePath, List <ImportResultModel> data)
{
//将List<ImportResultModel>转成ExcelModel后导出
var excelModel = new ExcelModel();
foreach (var sheet in data)
{
var excelSheetModel = new ExcelSheetModel();
excelSheetModel.Name = sheet.Title;
for (int row = 0; row < sheet.ErrorRows.Count; row++)
{
for (var col = 0; col < sheet.ErrorRows[row].Values.Count; col++)
{
var cell = new ExcelSheetCellModel();
cell.RowIndex = row + 2;
cell.ColumnIndex = col + 1;
cell.Value = sheet.ErrorRows[row].Values[col];
foreach (var error in sheet.ErrorRows[row].ErrorCols)
{
if (col == error.ColIndex)
{
cell.Errors.Add(error.Message);
}
}
excelSheetModel.Cells.Add(cell);
}
}
excelModel.Sheets.Add(excelSheetModel);
}
//_importExportService.Export(templateFilePath, data);
_importExportService.ExportWithTemplate(templateFilePath, excelModel);
}
public void ExportHealthResult(string templateFilePath, List <ImportResultModel> data)
{
var excelModel = new ExcelModel();
foreach (var sheet in data)
{
var excelSheetModel = new ExcelSheetModel();
excelSheetModel.Name = sheet.Title;
bool hasExtra = false;
for (int row = 0; row < sheet.ErrorRows.Count; row++)
{
if (sheet.ErrorRows[row].RowIndex == 0)
{
for (var col = 0; col < sheet.ErrorRows[row].Values.Count; col++)
{
var cell = new ExcelSheetCellModel();
cell.RowIndex = col + 2;
cell.ColumnIndex = 2;
cell.Value = sheet.ErrorRows[row].Values[col];
foreach (var error in sheet.ErrorRows[row].ErrorCols)
{
if (col == error.ColIndex)
{
cell.Errors.Add(error.Message);
}
}
excelSheetModel.Cells.Add(cell);
}
hasExtra = true;
}
else
{
for (var col = 0; col < sheet.ErrorRows[row].Values.Count; col++)
{
var cell = new ExcelSheetCellModel();
cell.RowIndex = hasExtra ? row + 8 : row + 9;
cell.ColumnIndex = col + 1;
cell.Value = sheet.ErrorRows[row].Values[col];
foreach (var error in sheet.ErrorRows[row].ErrorCols)
{
if (col == error.ColIndex)
{
cell.Errors.Add(error.Message);
}
}
excelSheetModel.Cells.Add(cell);
}
}
}
excelModel.Sheets.Add(excelSheetModel);
}
_importExportService.ExportWithTemplate(templateFilePath, excelModel);
}
