| | |
|---|
| | | dynamicSummaryYear(wb, year); |
|---|
| | | cleanSummarySheetPresentation(wb); // 取消各页筛选、还原隐藏行（否则“班线包车”等页看起来像缺数据） |
|---|
| | | applyTwoDecimalFormat(wb); // 数值显示两位小数（保留全精度）；% / 日期等既有样式不改变 |
|---|
| | | autoFitContentColumns(wb); // 按数据自动加宽列宽（只加宽不缩窄，跳过合并标题格，防长文本把单列撑爆） |
|---|
| | | if (!wb.getCTWorkbook().isSetCalcPr()) wb.getCTWorkbook().addNewCalcPr(); |
|---|
| | | wb.getCTWorkbook().getCalcPr().setFullCalcOnLoad(true); // 还原/改写公式后打开即重算 |
|---|
| | | return toBytes(wb); |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | 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); |
|---|
