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