poi hssfcellstyle 最多可以创建多少个样式对象

默认4000个，超出4000会报错：java.lang.IllegalStateException: The maximum number of cell styles was exceeded.You can define up to 4000 styles in a .xls workbook

使用 poi ，具体实现

HSSFCellStyle style = null

// 创建表头style

HSSFCellStyle cellStyleTitle = workbook.createCellStyle()

cellStyleTitle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND)// 填充单元格

cellStyleTitle.setFillForegroundColor(HSSFColor.YELLOW.index)

cellStyleTitle.setAlignment(HSSFCellStyle.ALIGN_CENTER)// //居中显示

HSSFRow titleRow = sheet.createRow(0)

for (int i = 0i <titles.lengthi++) {

HSSFCell cell = titleRow.createCell(i)

// cell.setCellStyle(createCellColorStyle(workbook))

cell.setCellStyle(cellStyleTitle)

cell.setCellValue(titles[i])// 给单元格赋值

}

不知道能，看懂不，如果有不清楚的私聊

//换成下面代码试试

ICellStyle style2 = hssfworkbook.CreateCellStyle()

style2.BorderBottom = NPOI.SS.UserModel.BorderStyle.THIN

style2.BorderLeft = NPOI.SS.UserModel.BorderStyle.THIN

style2.BorderRight = NPOI.SS.UserModel.BorderStyle.THIN

style2.BorderTop = NPOI.SS.UserModel.BorderStyle.THIN

style2.BorderDiagonal = BorderDiagonal.BACKWARD

style2.BorderDiagonalLineStyle = NPOI.SS.UserModel.BorderStyle.THIN

style2.Alignment = NPOI.SS.UserModel.HorizontalAlignment.LEFT

---