/// <summary>
/// 处理正文
/// </summary>
/// <param name="sheet">工作表</param>
/// <param name="innerSheet">NPOI工作表</param>
/// <param name="dataRowStartIndex">数据行起始索引</param>
private void HandleBody <TTemplate>(IWorkSheet sheet, ISheet innerSheet, int dataRowStartIndex)
{
var header = sheet.GetHeader().LastOrDefault();
for (var i = dataRowStartIndex; i < innerSheet.PhysicalNumberOfRows; i++)
{
var innerRow = innerSheet.GetRow(i);
if (innerRow == null || innerRow.Cells.All(x => string.IsNullOrWhiteSpace(x?.GetStringValue())))
{
continue;
}
sheet.AddBodyRow(Convert <TTemplate>(innerRow, header));
}
}
/// <summary>
/// 验证表头
/// </summary>
/// <param name="sheet">工作表</param>
/// <param name="options">导入选项配置</param>
private void VerifyHeader <TTemplate>(IWorkSheet sheet, IImportOptions options)
{
var header = sheet.GetHeader().LastOrDefault();
if (header == null)
{
throw new OfficeHeaderException($"导入的模板不正确，未匹配表头", options.HeaderRowIndex);
}
var cellNames = header.Cells.GroupBy(x => x.Name).Select(x => new { Name = x.Key, Count = x.Count() }).ToList();
if (options.HeaderColumnOnly && cellNames.Any(x => x.Count > 1))
{
throw new OfficeHeaderException($"导入的表格存在重复列:{cellNames.Where(x => x.Count > 1).Select(x => x.Name).ExpandAndToString()}", options.HeaderRowIndex);
}
if (!options.HeaderMatch)
{
return;
}
List <PropertyInfo> properties = typeof(TTemplate).GetProperties().ToList();
var props = properties
.Where(x => x.GetCustomAttribute <DynamicColumnAttribute>() == null)
.Where(x => x.GetCustomAttribute <ExcelIgnoreAttribute>() == null)
.Select(p => new
{
Name = p.GetCustomAttribute <ColumnNameAttribute>()?.Name,
Code = p.Name
}).ToList();
var cellName = cellNames.Select(x => x.Name);
var list = props.Where(p => !cellName.Contains(p.Name)).ToList();
if (list.Any())
{
list = list.Where(p => !(string.IsNullOrWhiteSpace(p.Name) && cellName.Contains(p.Code))).ToList();
if (list.Any())
{
throw new OfficeHeaderException($"导入的表格不存在列：{list.Select(x => string.IsNullOrWhiteSpace(x.Name) ? x.Code : x.Name).ExpandAndToString()}", options.HeaderRowIndex);
}
}
else if (options.MappingDictionary != null && options.MappingDictionary.Any())
{
var dic = options.MappingDictionary.ToList().Where(x => !cellName.Contains(x.Value)).ToList();
if (dic.Count > 0)
{
throw new OfficeHeaderException($"导入的表格不存在列：{dic.Select(x => x.Value).ExpandAndToString()}", options.HeaderRowIndex);
}
}
}
/// <summary>
/// 处理正文
/// </summary>
/// <param name="sheet">工作表</param>
/// <param name="innerSheet">NPOI工作表</param>
/// <param name="dataRowStartIndex">数据行起始索引</param>
/// <param name="enabledEmptyLine">启用空行模式。启用时，行内遇到空行将抛出异常错误信息</param>
private void HandleBody <TTemplate>(IWorkSheet sheet, ISheet innerSheet, int dataRowStartIndex, bool enabledEmptyLine)
{
var header = sheet.GetHeader().LastOrDefault();
// LastRowNum: 获取最后一行的行数，如果sheet中一行数据都没有则返回-1，只有第一行有数据则返回0，最后有数据的行是第n行则返回n-1
// PhysicalNumberOfRows: 获取有记录的行数，即：最后有数据的行是第n行，前面有m行是空行没数据，则返回n-m
for (var i = dataRowStartIndex; i < innerSheet.GetHasDataRowNum() + 1; i++)
{
var innerRow = innerSheet.GetRow(i);
if (CheckEmptyLine(innerRow.IsEmptyRow(), enabledEmptyLine))
{
continue;
}
sheet.AddBodyRow(Convert <TTemplate>(innerRow, header));
}
}
/// <summary>
/// 处理正文
/// </summary>
/// <param name="sheet">工作表</param>
/// <param name="innerSheet">NPOI工作表</param>
/// <param name="options">导入选项配置</param>
private void HandleBody <TTemplate>(IWorkSheet sheet, ISheet innerSheet, IImportOptions options)
{
var header = sheet.GetHeader().LastOrDefault();
// LastRowNum: 获取最后一行的行数，如果sheet中一行数据都没有则返回-1，只有第一行有数据则返回0，最后有数据的行是第n行则返回n-1
// PhysicalNumberOfRows: 获取有记录的行数，即：最后有数据的行是第n行，前面有m行是空行没数据，则返回n-m
for (var i = options.DataRowIndex; i < innerSheet.GetHasDataRowNum() + 1; i++)
{
var innerRow = innerSheet.GetRow(i);
if (CheckIgnoreEmptyLine(options, innerRow.IsEmptyRow()))
{
break;
}
if (CheckEmptyLine(innerRow.IsEmptyRow(), options.EnabledEmptyLine, i))
{
continue;
}
sheet.AddBodyRow(Convert <TTemplate>(innerRow, header), innerRow.RowNum);
}
}
