Springboot导出excel工具类

最新推荐文章于 2024-08-03 21:02:21 发布

chao ge

最新推荐文章于 2024-08-03 21:02:21 发布

阅读量344

点赞数

分类专栏：工具类文章标签： java apache 后端 spring

本文链接：https://blog.csdn.net/qq_40598427/article/details/122337166

版权

1、简介

这次是使用XSSFWorkbook方法导出。

2、导入依赖

<!--poi依赖-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-scratchpad</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>com.deepoove</groupId>
            <artifactId>poi-tl</artifactId>
            <version>1.3.1</version>
        </dependency>

3、工具类

import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.xssf.usermodel.*;
 
import javax.servlet.http.HttpServletResponse;
import java.io.OutputStream;
import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;
 
public class ExcelUtils {
 
    public static <T> void setExcelProperty(String fileNameParam, HttpServletResponse response, List listTi