alibaba EasyExcel 简单导出数据到Excel

SUMMERENT

已于 2024-07-04 14:22:47 修改

阅读量470

点赞数 3

文章标签： java 前端服务器

于 2024-07-03 10:10:08 首次发布

本文链接：https://blog.youkuaiyun.com/SUMMERENT/article/details/140144592

版权

导入依赖

<dependency>
     <groupId>com.alibaba</groupId>
     <artifactId>easyexcel</artifactId>
     <version>4.0.1</version>
</dependency>

1、alibaba.excel.EasyExcel导出工具类

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;

import javax.servlet.http.HttpServletResponse;
import java.net.URLEncoder;
import java.util.List;

public class ExcelUtil {

    /**
     * 导出excel
     *
     * @param response 响应
     * @param list 数据集
     * @param clazz 类名
     * @param fileName 文件名
     * @return
     */
    public static<T> void exportExcel(HttpServletResponse response, List<T> list, Class<T> clazz, String fileName) {
        try {
            response.setCharacterEncoding("utf-8");
            response.setContentType("application/vnd.ms-e