1.4000最大样式错误
java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook错误
找到zpoi.jar中org.zkoss.poi.hssf.usermodel.HSSFWorkbook修改createCellStyle函数内的最大样式数量即可。重新打zpoi.jar即可。
- public HSSFCellStyle createCellStyle()
- {
- if(workbook.getNumExFormats() == MAX_STYLES) {
- throw new IllegalStateException("The maximum number of cell styles was exceeded. " +
- "You can define up to 4000 styles in a .xls workbook");
- }
- ExtendedFormatRecord xfr = workbook.createCellXF();
- short index = (short) (getNumCellStyles() - 1);
- HSSFCellStyle style = new HSSFCellStyle(index, xfr, this);
- workbook.createCellXFExt(index);
- return style;
- }
2.IE兼容问题
如果IE系列的浏览器出现了兼容问题(具体就是显示不出报表来),我已知的可能出现的问题有,Excel模板里有数字已字符串形式写入,或者是写日期格式的单元格出现了写入错误。具体的解决如下。
- public static Cell writeNumericValue(Sheet sheet, int row, int column,
- Double value) {
- Row poiRow = sheet.getRow(row);
- if (poiRow == null) {
- poiRow = sheet.createRow(row);
- }
- Cell poiCell = poiRow.getCell(column);
- if (poiCell != null) {
- poiRow.removeCell(poiCell);
- }
- poiCell = poiRow.createCell(column);
- poiCell.setCellType(Cell.CELL_TYPE_NUMERIC);
- poiCell.setCellValue(value);
- return poiCell;
- }
- public static Cell writeDateValue(Workbook book, Sheet sheet, int row,
- int column, Date value) {
- Row poiRow = sheet.getRow(row);
- CreationHelper createHelper = book.getCreationHelper();
- if (poiRow == null) {
- poiRow = sheet.createRow(row);
- }
- Cell poiCell = poiRow.getCell(column);
- if (poiCell == null) {
- poiCell = poiRow.createCell(column);
- }
- CellStyle cellStyle = book.createCellStyle();
- cellStyle.setDataFormat(createHelper.createDataFormat().getFormat(
- "yyyy-mm-dd"));
- if (value != null) {
- poiCell.setCellValue(value);
- } else {
- poiCell.setCellValue(new Date());
- }
- poiCell.setCellStyle(cellStyle);
- return poiCell;
- }