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