| | |
|---|
| | | try (InputStream in = new FileInputStream(template); |
|---|
| | | XSSFWorkbook wb = new XSSFWorkbook(in)) { |
|---|
| | | dynamicSummaryYear(wb, year); |
|---|
| | | applyTwoDecimalFormat(wb); |
|---|
| | | autoFitContentColumns(wb); // 汇总表导出后按内容加宽列宽（只加宽不缩窄） |
|---|
| | | return toBytes(wb); |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | CellType ct = cell.getCellType(); |
|---|
| | | if (ct != CellType.NUMERIC && ct != CellType.FORMULA) continue; |
|---|
| | | if (org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted(cell)) continue; |
|---|
| | | if (ct == CellType.NUMERIC && Math.rint(cell.getNumericCellValue()) == cell.getNumericCellValue()) continue; |
|---|
| | | boolean integral = false; |
|---|
| | | if (ct == CellType.NUMERIC) { |
|---|
| | | integral = Math.rint(cell.getNumericCellValue()) == cell.getNumericCellValue(); |
|---|
| | | } else if (cell.getCachedFormulaResultType() == CellType.NUMERIC) { |
|---|
| | | integral = Math.rint(cell.getNumericCellValue()) == cell.getNumericCellValue(); |
|---|
| | | } |
|---|
| | | if (integral) continue; // 整数不显示 .00（含公式结果为整数的格） |
|---|
| | | org.apache.poi.ss.usermodel.CellStyle cs = cell.getCellStyle(); |
|---|
| | | if (cs == null) continue; |
|---|
| | | String f = cs.getDataFormatString(); |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** 汇总表导出后按内容自动加宽列宽（只加宽不缩窄；跳过合并单元格标题，防长标题把单列撑爆） */ |
|---|
| | | private void autoFitContentColumns(org.apache.poi.ss.usermodel.Workbook wb) { |
|---|
| | | if (wb == null) return; |
|---|
| | | org.apache.poi.ss.usermodel.DataFormatter dfmt = new org.apache.poi.ss.usermodel.DataFormatter(); |
|---|
| | | for (int s = 0; s < wb.getNumberOfSheets(); s++) { |
|---|
| | | org.apache.poi.ss.usermodel.Sheet sh = wb.getSheetAt(s); |
|---|
| | | if (sh == null) continue; |
|---|
| | | java.util.Set<String> merged = new java.util.HashSet<>(); |
|---|
| | | for (org.apache.poi.ss.util.CellRangeAddress ra : sh.getMergedRegions()) { |
|---|
| | | for (int r = ra.getFirstRow(); r <= ra.getLastRow(); r++) { |
|---|
| | | for (int c = ra.getFirstColumn(); c <= ra.getLastColumn(); c++) { |
|---|
| | | merged.add(r + ":" + c); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | int maxCol = -1; |
|---|
| | | for (org.apache.poi.ss.usermodel.Row row : sh) { |
|---|
| | | if (row == null) continue; |
|---|
| | | maxCol = Math.max(maxCol, (int) row.getLastCellNum() - 1); |
|---|
| | | } |
|---|
| | | if (maxCol < 0) continue; |
|---|
| | | int[] need = new int[maxCol + 1]; |
|---|
| | | for (org.apache.poi.ss.usermodel.Row row : sh) { |
|---|
| | | if (row == null) continue; |
|---|
| | | for (org.apache.poi.ss.usermodel.Cell cell : row) { |
|---|
| | | int c = cell.getColumnIndex(); |
|---|
| | | if (c > maxCol || merged.contains(row.getRowNum() + ":" + c)) continue; |
|---|
| | | String txt; |
|---|
| | | try { |
|---|
| | | txt = dfmt.formatCellValue(cell); |
|---|
| | | } catch (Exception ignore) { |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | | if (txt == null || txt.isEmpty()) continue; |
|---|
| | | int units = 0; |
|---|
| | | for (int i = 0; i < txt.length(); i++) { |
|---|
| | | units += isWideChar(txt.charAt(i)) ? 2 : 1; |
|---|
| | | } |
|---|
| | | if (units > need[c]) need[c] = Math.min(units, 34); // 长文本不把单列撑爆 |
|---|
| | | } |
|---|
| | | } |
|---|
| | | for (int c = 0; c <= maxCol; c++) { |
|---|
| | | if (need[c] <= 0) continue; |
|---|
| | | int target = Math.min(need[c] + 2, 46) * 256; |
|---|
| | | if (target > sh.getColumnWidth(c)) sh.setColumnWidth(c, target); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** CJK / 全角字符按两倍宽度计（近似 Excel 显示列宽） */ |
|---|
| | | private boolean isWideChar(char ch) { |
|---|
| | | return (ch >= 0x2E80 && ch <= 0x9FFF) || (ch >= 0xF900 && ch <= 0xFAFF) |
|---|
| | | || (ch >= 0xFF00 && ch <= 0xFFEF); |
|---|
| | | } |
|---|
| | | |
|---|
| | | private byte[] toBytes(XSSFWorkbook wb) throws Exception { |
|---|
| | | applyTwoDecimalFormat(wb); |
|---|
| | | try (ByteArrayOutputStream out = new ByteArrayOutputStream()) { |
|---|
