From 7035ddf9bf670d7cf2902434305517e5a86cbcd8 Mon Sep 17 00:00:00 2001 From: yuxc <yuxc@vci-tech.com> Date: 星期五, 09 八月 2024 09:40:44 +0800 Subject: [PATCH] 1、新增检查查询模板是否存在接口。 2、新增查询模板列表接口。 3、新增查询条件的查询按钮查询lis列表。 --- Source/plt-web/plt-web-parent/plt-poi/src/main/java/com/vci/starter/poi/util/ExcelUtil.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/Source/plt-web/plt-web-parent/plt-poi/src/main/java/com/vci/starter/poi/util/ExcelUtil.java b/Source/plt-web/plt-web-parent/plt-poi/src/main/java/com/vci/starter/poi/util/ExcelUtil.java index aedbcdf..2ed445e 100644 --- a/Source/plt-web/plt-web-parent/plt-poi/src/main/java/com/vci/starter/poi/util/ExcelUtil.java +++ b/Source/plt-web/plt-web-parent/plt-poi/src/main/java/com/vci/starter/poi/util/ExcelUtil.java @@ -1,5 +1,6 @@ package com.vci.starter.poi.util; +import cn.hutool.core.collection.CollUtil; import com.vci.starter.poi.annotation.ExcelColumn; import com.vci.starter.poi.annotation.ExcelTitle; import com.vci.starter.poi.bo.*; @@ -630,6 +631,8 @@ //鍐欏�� setCellValue(cell, value); } + //璁剧疆鑷�傚簲鍒楀 + sheet.autoSizeColumn(ed.getCol()); if(ed.getWidth()!=null && ed.getWidth()>0){ sheet.setColumnWidth(cell.getColumnIndex(),(int)(ed.getWidth() + 0.72)*256); } @@ -855,6 +858,7 @@ if (ed.getColTo() < ed.getCol()) { ed.setColTo(ed.getCol()); } + List<CellRangeAddress> cellRangeAddressList = sheet.getMergedRegions(); sheet.addMergedRegion(new CellRangeAddress(ed.getRow(), ed.getRowTo(), ed.getCol(), ed.getColTo())); }); } -- Gitblit v1.9.3