NPOI设定某个格子的样式
XSSFCellStyle headStyle = workBook.CreateCellStyle() as XSSFCellStyle;
headStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
XSSFFont font = workBook.CreateFont() as XSSFFont;
font.FontHeightInPoints = 10;
font.Boldweight = 700;
font.Color = IndexedColors.Red.Index;
headStyle.SetFont(font);
IRow gapRow = sheet.CreateRow(lineCount);
gapRow.CreateCell(3 + i).SetCellValue(line4[i]);
if (line4[i] != 0)
{
gapRow.GetCell(3 + i).CellStyle = headStyle;
}
主要问题是两个as不能省。
浙公网安备 33010602011771号