easyexcel 设置标题_使用easyexcel完成复杂表头及标题的导出功能(自定义样式)

如需客户端指定excel版本,只需要判断后缀名然后在controller中的.excelType(ExcelTypeEnum.XLS)做指定输出内容格式即可

***(注意表格行高列宽统一设置是在实体类的类名注解上,如果需要对表格进行精细的宽高设置需要删除掉这两个注解,可以在拦截器使用row的方法进行设置)

1. ## 引入依赖

com.alibaba

easyexcel

2.1.4

2.实体类(注解法)

package com.jpxx.admin.pilebody.service.api.dto;

import com.alibaba.excel.annotation.ExcelIgnore;

import com.alibaba.excel.annotation.ExcelProperty;

import com.alibaba.excel.annotation.write.style.ColumnWidth;

import com.alibaba.excel.annotation.write.style.ContentRowHeight;

import com.alibaba.excel.annotation.write.style.HeadRowHeight;

import com.alibaba.excel.util.StringUtils;

import lombok.Data;

import lombok.NoArgsConstructor;

import lombok.experimental.Accessors;

@Data

@NoArgsConstructor

@Accessors(chain = true)

@ContentRowHeight(45)

@HeadRowHeight(50)

public class PilebodycheckMonthDto {

@ExcelIgnore

private String id;

@ExcelIgnore

private String cityid;

@ExcelIgnore

private String districtid;

@ExcelProperty(value = {"序号","序号"},index = 0)

@ColumnWidth(10)

private String orderNum;

@ExcelProperty(value = {"堆体名称","堆体名称"},index = 1)

@ColumnWidth(15)

private String name;

@ExcelProperty(value = {"具体位置","具体位置"},index = 3)

@ColumnWidth(30)

private String address;

@ExcelProperty(value = {"占地面积(平方)","占地面积(平方)"},index = 4)

@ColumnWidth(15)

private String areastr;

@ExcelProperty(value = {"堆体高度(米)","堆体高度(米)"},index = 5)

@ColumnWidth(10)