/// <summary> /// 处理表头 /// </summary> /// <param name="sheet">工作表</param> /// <param name="innerSheet">NPOI工作表</param> /// <param name="headerRowIndex">标题行索引</param> private void HandleHeader(IWorkSheet sheet, ISheet innerSheet, int headerRowIndex) { var innerRow = innerSheet.GetRow(headerRowIndex); var cells = new List <ICell>(); foreach (var cell in innerRow.Cells.Where(x => !string.IsNullOrEmpty(GetStringValue(x)))) { cells.Add(new Cell(GetStringValue(cell)) { ColumnIndex = cell.ColumnIndex, Name = GetStringValue(cell) }); } sheet.AddHeadRow(cells.ToArray()); }
/// <summary> /// 处理表头 /// </summary> /// <param name="sheet">工作表</param> /// <param name="innerSheet">NPOI工作表</param> /// <param name="headerRowIndex">标题行索引</param> private void HandleHeader(IWorkSheet sheet, ISheet innerSheet, int headerRowIndex) { var innerRow = innerSheet.GetRow(headerRowIndex); var cells = new List <ICell>(); for (var i = 0; i < innerRow.PhysicalNumberOfCells; i++) { var innerCell = innerRow.GetCell(i); cells.Add(new Cell(innerCell.GetStringValue()) { ColumnIndex = i, Name = innerCell.GetStringValue() }); } sheet.AddHeadRow(cells.ToArray()); }
/// <summary> /// 添加表头 /// </summary> /// <param name="titles">列标题</param> /// <returns></returns> public IExport Head(params string[] titles) { Sheet.AddHeadRow(titles); return(this); }