【easyExcel 导出内容自适应】

easyExcel 导出内容自适应

import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.Head;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.style.column.AbstractColumnWidthStyleStrategy;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Sheet;import java.util.HashMap;
import java.util.List;
import java.util.Map;public class CustomCellWriteHandler extends AbstractColumnWidthStyleStrategy {private static final int MAX_COLUMN_WIDTH = 255;private  Map<Integer, Map<Integer, Integer>> CACHE = new HashMap(8);public CustomCellWriteHandler() {}protected void setColumnWidth(WriteSheetHolder writeSheetHolder, List<CellData> cellDataList, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {boolean needSetWidth = isHead || !CollectionUtils.isEmpty(cellDataList);if (needSetWidth) {Map<Integer, Integer> maxColumnWidthMap = (Map)CACHE.get(writeSheetHolder.getSheetNo());if (maxColumnWidthMap == null) {maxColumnWidthMap = new HashMap(16);CACHE.put(writeSheetHolder.getSheetNo(), maxColumnWidthMap);}Integer columnWidth = this.dataLength(cellDataList, cell, isHead);if (columnWidth >= 0) {if (columnWidth > 255) {columnWidth = 255;}Integer maxColumnWidth = (Integer)((Map)maxColumnWidthMap).get(cell.getColumnIndex());if (maxColumnWidth == null || columnWidth > maxColumnWidth) {((Map)maxColumnWidthMap).put(cell.getColumnIndex(), columnWidth);writeSheetHolder.getSheet().setColumnWidth(cell.getColumnIndex(), columnWidth * 256);}}}}private Integer dataLength(List<CellData> cellDataList, Cell cell, Boolean isHead) {if (isHead) {return cell.getStringCellValue().getBytes().length;} else {CellData cellData = (CellData)cellDataList.get(0);CellDataTypeEnum type = cellData.getType();if (type == null) {return -1;} else {switch(type) {case STRING:return cellData.getStringValue().getBytes().length+6;case BOOLEAN:return cellData.getBooleanValue().toString().getBytes().length+6;case NUMBER:return cellData.getNumberValue().toString().getBytes().length+6;default:return -1;}}}}
}

新建测试类

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.support.ExcelTypeEnum;
import com.alibaba.excel.write.handler.CellWriteHandler;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.metadata.style.WriteCellStyle;
import com.alibaba.excel.write.metadata.style.WriteFont;
import com.alibaba.excel.write.style.HorizontalCellStyleStrategy;
import javafx.application.Application;
import javafx.stage.Stage;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.dream.pay.report.report.vo.D0RecordModelManagerExcelVo;
import org.springframework.beans.BeanUtils;import java.io.File;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.ArrayList;
import java.util.List;public class Test {private final static String path = "F:\\stock\\html\\upload";public static void main(String[] args) {ExcelWriter writerRTGS = null;WriteSheet writeSheetRTGS = null;List<D0RecordModelManagerExcelVo> listRTGS = new ArrayList<>();File dest = new File(path);if (!dest.exists()) {dest.mkdirs();}int index_RTGS = 0;StringBuilder localPath = new StringBuilder();D0RecordModelManagerExcelVo d0RecordModelManagerExcelVo = new D0RecordModelManagerExcelVo();String accountNumber = "62148231231239123919";d0RecordModelManagerExcelVo.setAccountNumber( accountNumber);d0RecordModelManagerExcelVo.setSnorefno("2023062501");String settleAmountString = "1000000000001";d0RecordModelManagerExcelVo.setSettleAmountString(settleAmountString);d0RecordModelManagerExcelVo.setDescription("settlement");d0RecordModelManagerExcelVo.setCity("杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州杭州");if (writerRTGS == null) {String exportPath = path + "/" + "20230626" + "_RTGS_settlement";String fileName = exportPath + ExcelTypeEnum.XLSX.getValue();localPath.append(fileName).append(",");writerRTGS = EasyExcel.write(fileName, D0RecordModelManagerExcelVo.class).registerWriteHandler(new CustomCellWriteHandler()).build();//写第一个sheet,数据全是List<String> 无模型映射关系writeSheetRTGS = EasyExcel.writerSheet(1).registerWriteHandler(getStyleStrategy()).build();//设置sheetNamewriteSheetRTGS.setSheetName("20230625" + "_RTGS_settlement");}String SNO_REF_NO = "20230625";index_RTGS++;if (index_RTGS < 10) {SNO_REF_NO = SNO_REF_NO + "0" + index_RTGS;} else {SNO_REF_NO = SNO_REF_NO + index_RTGS;}if (SNO_REF_NO != null) {d0RecordModelManagerExcelVo.setSnorefno( SNO_REF_NO);}listRTGS.add(d0RecordModelManagerExcelVo);if (CollectionUtils.isNotEmpty(listRTGS)) {writerRTGS.write(listRTGS, writeSheetRTGS);}writerRTGS.finish();}/*** 表格内容样式* @return*/public static HorizontalCellStyleStrategy getStyleStrategy(){//表头样式WriteCellStyle headWriteCellStyle = new WriteCellStyle();//字体WriteFont headWriteFont = new WriteFont();headWriteFont.setFontHeightInPoints((short) 11);headWriteFont.setBold(true);headWriteCellStyle.setWriteFont(headWriteFont);//边框headWriteCellStyle.setBorderBottom(BorderStyle.THIN);headWriteCellStyle.setBorderLeft(BorderStyle.THIN);headWriteCellStyle.setBorderRight(BorderStyle.THIN);//前景色headWriteCellStyle.setFillForegroundColor(IndexedColors.WHITE.getIndex());//是否换行headWriteCellStyle.setWrapped(true);headWriteCellStyle.setLocked(true);//表体样式WriteCellStyle bodyWriteCellStyle = new WriteCellStyle();//设置数据格式索引bodyWriteCellStyle.setDataFormat((short)49);//bodyWriteCellStyle.setWriteFont(headWriteFont);//边框bodyWriteCellStyle.setBorderBottom(BorderStyle.THIN);bodyWriteCellStyle.setBorderLeft(BorderStyle.THIN);bodyWriteCellStyle.setBorderRight(BorderStyle.THIN);bodyWriteCellStyle.setHidden(true);bodyWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);bodyWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);// 设置单引号bodyWriteCellStyle.setQuotePrefix(true);return new HorizontalCellStyleStrategy(headWriteCellStyle, bodyWriteCellStyle);}
}

效果如下

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！