EasyExcel(alibaba)导入导出

最新推荐文章于 2024-07-02 11:52:14 发布

juanjuanya.

最新推荐文章于 2024-07-02 11:52:14 发布

阅读量297

点赞数

分类专栏：笔记文章标签： excel java

本文链接：https://blog.csdn.net/m0_60536467/article/details/128862980

版权

笔记专栏收录该内容

4 篇文章 1 订阅

订阅专栏

导入：

ExcelReadBuilder excelBuilder = EasyExcel.read();
excelBuilder.file(A);
excelBuilder.head(ExcelData.class);
excelBuilder.sheet(B);
excelBuilder.autoCloseSteam(true);
excelBuilder.excelType(ExcelTypeEnum.XLSX);
excelBuilder.registerReadListener(new AnalysisEventListener<泛型>);

导出

1.导出功能

EasyExcel.write(A)
.registerWriteHandler（horizontalCellStyleStrategy）
.registerWriteHandler（loopMergeStrategy）
.head(ExcelData.class)
.excelType(ExcelTypeEnum.XLS)
.sheet(B)
.dowrite(C);

2.导出EXCEL样式

1.头部标题样式

WriteCellStyle headWriteCellStyle = new WriteCellStyle();
WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle);

2.样式

.setHorizontalAlignment(HorizontalAlignment.CENTER);
.setVerticalAlignment(VerticalAlignment.CENTER);
.setWrapped(true);
WriteFont headWriteFont = new WriteFont();
headWriteFont.setFontHeightInPoints((short) 36);
.setWriteFont(headWriteFont);
.setBorderBottom(BorderStyle.NONE);
.setBorderLeft(BorderStyle.NONE);
.setBorderRight(BorderStyle.NONE);
.setBorderTop(BorderStyle.NONE);
LoopMergeStrategy loopMergeStrategy = new LoopMergeStrategy(eachRow, columnCount, columnIndex);