export-to-excel - Region,CELL_TYPE_NUMERIC 无法解析为类型错误

Question

我在我的项目中共享了一些代码。需要将代码从 apache poi 3.9 迁移到 poi 4.0.1 wb = new HSSFWorkbook();

            sheet = wb.createSheet("BondSummary");  
            //Reports-BS-001 starts
            HSSFCellStyle dateStyle = wb.createCellStyle();
            dateStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));
            java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("dd/MM/yyyy");
            java.text.SimpleDateFormat formatter1 = new java.text.SimpleDateFormat("MM/dd/yyyy");
            HSSFCellStyle bondStyle = wb.createCellStyle();
            //bondStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("0"));//Reports-BS-004
            bondStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("#,##0"));//Reports-BS-004
            HSSFCellStyle bondValStyle = wb.createCellStyle();
            bondValStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("($#,##0.00_);[Red]($#,##0.00)"));
            sheet.setColumnWidth((short)0,(short)5000);
            sheet.setColumnWidth((short)1,(short)5000);
            sheet.setColumnWidth((short)2,(short)5000);
            sheet.setColumnWidth((short)3,(short)5000);
            sheet.setColumnWidth((short)4,(short)5000);
            sheet.setColumnWidth((short)5,(short)5000);
            sheet.setColumnWidth((short)6,(short)5000);
            //Reports-BS-001 ends

            
            HSSFRow row0  = sheet.createRow((short)0);
            sheet.addMergedRegion(new Region(0, (short)0, 0, (short)5));
            HSSFCell cell=row0.createCell((short)0);
            cell.setCellValue("Bond Summary Report");           //First Row
            cell.setCellStyle(ExcelUtility.getHeaderstyle(wb));

            

标签： export-to-excel