spring项目使用poi导出xlsx表格

引入poi依赖

 <!--Excel依赖 完成读写xlsx-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml-schemas</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.17</version>
        </dependency>

JS代码

实现异步导出方法

function Export() {
    //obj视使用情况改变，代表你需要写入表格的数据
    let obj ={};
    var d = new Date();
    let filename=d.getFullYear()+''+
        d.getMonth()+''+d.getDay()+''+
        d.getHours()+''+d.getMinutes()+''+
        d.getSeconds()+''+' 表名.xlsx';
    var xhr = new XMLHttpRequest();
    xhr.open('get', '/excel/Excel?obj='+obj, true);
    xhr.responseType = 'blob';
    xhr.setRequestHeader('Content-Type', 'application/json;charset=utf-8');
    xhr.onload = function () {
        if (this.status == 200) {
            var blob = this.response;
            var a = document.createElement('a');
            var url = window.URL.createObjectURL(blob);
            a.href = url;
            //设置文件名称
            a.download = filename;
            a.click();
        }
    }
    xhr.send();
}

图表模板—TemplateChart类

视使用情况修改表头和内容方法

import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.HashMap;
import java.util.List;


import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.u