easyExcel导出表格及合并单元格
前言
废话不多说,直接上效果图。
效果图
合并之前导出的:
合并之后导出的:
代码的实现主要是合并之后的,为了更好的分清数据之间的关系。
二、代码
目录 <只需要注意红色的>
easyExcel依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.6</version>
</dependency>
controller
package com.wondersgroup.easyexceldome.controller;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.support.ExcelTypeEnum;
import com.wondersgroup.easyexceldome.dto.BizMergeStrategy;
import com.wondersgroup.easyexceldome.dto.RowRangeDto;
import com.wondersgroup.easyexceldome.dto.TitleSheetWriteHandler;
import com.wondersgroup.easyexceldome.model.Student;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
/**
* <p>
* 该类的描述
* </p>
*
* @author
* @Modified By:
* @since 2020/11/23 11:31
*/
@RestController
@RequestMapping("/user")
public class EasyExcelController {
@GetMapping("/excel")
public void excel(HttpServletResponse response) throws IOException {
Map<String, List<RowRangeDto>> strategyMap = BizMergeStrategy.addAnnualMerStrategy(data());
try {
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
// 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
String filename = URLEncoder.encode("用户表测试", "UTF-8").replaceAll("\\+", "%20");
response.setHeader("Content-disposition", "attachment;filename=" + filename + ".xlsx");
EasyExcel.write(response.getOutputStream(), Student.class)
.excelType(ExcelTypeEnum.XLSX).head(Student.class)
//.registerWriteHandler(new TitleSheetWriteHandler("我是一个小标题",2)) // 标题及样式,lastCol为标题第0列到底lastCol列的宽度
//设置默认样式及写入头信息开始的行数
.relativeHeadRowIndex(1)
.registerWriteHandler(new BizMergeStrategy(strategyMap)) // 注册合并策略
.registerWriteHandler(BizMergeStrategy.CellStyleStrategy()) // 设置样式
.sheet("测试")
.doWrite(data());
}catch (Exception e) {
e.printStackTrace();
response.reset