使用easyexcel导出多表头excel文件

最新推荐文章于 2025-11-13 18:34:00 发布

原创最新推荐文章于 2025-11-13 18:34:00 发布 · 1.3w 阅读

19 ·

CC 4.0 BY-SA版权

阿里巴巴盒马大量招聘 hc多多提供全程面试辅导简历砸过来 laixiaoxing.lxx@alibaba-inc.com 5年内的p6 7年以上的p7 机会多多

java 专栏收录该内容

70 篇文章

订阅专栏

本文介绍如何利用EasyExcel库创建并导出包含多层表头的Excel文件，详细步骤参考链接提供了两个优快云博客文章，详细阐述了实现方法和效果展示。

多表头的model

package com.souche.financial.report.model.eo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.BaseRowModel;
import lombok.Data;
import org.springframework.util.Assert;

import java.math.BigDecimal;

/**
 * @author weiyu
 * @version V1.0
 * @since 2019-01-28
 */
@Data
public class TaxVerificationOutEO extends BaseRowModel {
    @ExcelProperty(value = {"帐套编码","帐套编码"},index = 0)
    private String organizeId;

    @ExcelProperty(value = {"帐套名称","帐套名称"},index = 1)
    private String organizeName;

    @ExcelProperty(value = {"税款所属期","税款所属期"},index = 2)
    private String verificationDate;

    @ExcelProperty(value={ "上期留抵税额","申报值"},index = 3)
    private BigDecimal basisTax;
    @ExcelProperty(value = {"上期留抵税额","差异"},index = 4)
    private BigDecimal basisTaxDiff;

    @ExcelProperty(value = {"本期销项","申报值"},index = 5)
    private BigDecimal outputTax;
    @ExcelProperty(value = {"本期销项","差异"},index = 6)
    private BigDecimal outputTaxDiff;

    @ExcelProperty(value = {"本期进项","申报值"},index = 7)
    private BigDecimal inputTax;
    @ExcelProperty(value = {"本期进项","差异"},index = 8)
    private BigDecimal inputTaxDiff;


    @ExcelProperty(value = {"进项转出","申报值"},index = 9)
    private BigDecimal inputTransfer;
    @ExcelProperty(value ={"进项转出", "差异"},index = 10)
    private BigDecimal inputTransferDiff;


    @ExcelProperty(value = {"本期留抵税额","申报值"},index = 11)
    private BigDecimal taxResult;
    @ExcelProperty(value = {"本期留抵税额","差异"},index = 12)
    private BigDecimal taxResultDiff;
}

效果
在这里插入图片描述