定义填充整列样式函数
/// <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);