NPOI填充整列样式

定义填充整列样式函数 

/// <summary>
/// 填充列样式
/// </summary>
/// <param name="ws">ISheet实例</param>
/// <param name="col">列索引</param>
/// <param name="style">样式</param>
public void FillWholeColStyle(ISheet ws, int col, ICellStyle style)
{
    int firstRowNum=ws.FirstRowNum;
    int lastRowNum=ws.LastRowNum;
    int rowstart = firstRowNum;
    int rowend = lastRowNum;
    int colstart = col;
    int colend = col;
    ICellRange<ICell> cellRange = GetCellRange(ws, new CellRangeAddress(rowstart, rowend, colstart, colend));
    foreach (ICell c in cellRange)
    {
        c.CellStyle = style;
    }
    ws.SetDefaultColumnStyle(col,style);           
}

GetCellRange()函数请查看https://blog.csdn.net/chlung/article/details/83085215

使用函数

IWorkbook wb = new XSSFWorkbook();
ISheet ws= wb.CreateSheet("Sheet1");
ICellStyle style= wb.CreateCellStyle();
int col=1    //列索引

FillWholeColStyle(ws,col,style);