首页 >> 知识 >> Springboot生成并导出Excel(使用POI)

Springboot生成并导出Excel(使用POI)

    文件下载的工作原理还是依靠了HTTP协议提供了文件下载功能。

 SpringBoot集成POI,导出excel文件非常方便。首先引入所需要的poi  jar包,然后在Controller层实现相关的业务代码即可。话不多说,直接上代码吧。

1.配置pom.xml

org.apache.poi poi 3.17

 

2.在controller层添加如下代码:

import org.apache.poi.hssf.usermodel.*;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import javax.servlet.http.HttpServletResponse;import java.io.IOException;/** * Excel表格导出接口 * http://localhost:8080/ExcelDownload * @param response response对象 * @throws IOException 抛IO异常 */ @RequestMapping("/ExcelDownload") public void excelDownload(HttpServletResponse response) throws IOException { //表头数据 String[] header = {"姓名", "工号", "性别", "出生日期", "身份证号码", "婚姻状况","民族","籍贯","政治面貌","电子邮件","电话号码","联系地址","所属部门","职位","职称","聘用形式","入职日期","转正日期","合同起始日期","合同截止日期","合同期限","最高学历"}; //
网站地图