Java导出完整版模板（export）

最新推荐文章于 2024-04-24 17:58:01 发布

置顶

飘＊

最新推荐文章于 2024-04-24 17:58:01 发布

阅读量2.6k

点赞数 2

CC 4.0 BY-SA版权

分类专栏：导入导出文章标签：导出

本文链接：https://blog.youkuaiyun.com/weixin_44568752/article/details/90713265

1.在pom引入jra包

<!--导入导出excel-->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.15</version>
    <exclusions>
        <exclusion>
            <groupId>stax</groupId>
            <artifactId>stax-api</artifactId>
        </exclusion>
    </exclusions>
</dependency>

2.导出模板(util文件)

import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.xssf.streaming.SXSSFCell;
import org.apache.poi.xssf.streaming.SXSSFRow;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFRichTextString;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.List;

@Slf4j
public class ExportExcelStandard {
    private String sheetName; // 导出表格的表名
    private String[] rowName;// 导出表格的列名
    private List<LinkedHashMap<String, Object>> dataList = new ArrayList<>(); // 对象数组的List集合
    private HttpServletResponse response;
    private HttpServletRequest request;
    private String fileName;
    private String filePath;

    public ExportExcelStandard(String sheetName, String[] rowName, List<LinkedHashMap<String, Object>> dataList, HttpServletRequest request, HttpServletResponse response) {
        this.rowName = rowName;
        this.dataList =