Java使用easyExcel

最新推荐文章于 2025-04-27 10:11:34 发布

南京热心市民

最新推荐文章于 2025-04-27 10:11:34 发布

阅读量289

点赞数

文章标签： java excel 开发语言

本文链接：https://blog.youkuaiyun.com/weixin_42471125/article/details/130370507

版权

1.导包
pom文件导入

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


import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.style.column.SimpleColumnWidthStyleStrategy;
import com.alibaba.excel.write.style.row.SimpleRowHeightStyleStrategy;
import java.net.URLEncoder;

public class expertUti{
 public static void export(HttpServletResponse response,List excelList,Class clazz,String fileName,String sheetName,Integer sheetNo){
        try {
            fileName = URLEncoder.encode("xxx.xlsx", "UTF-8");
            response.setHeader("content-Type", "application/vnd.ms-excel;charset=utf-8");
            response.addHeader("Content-Disposition", "attachment;filename=\"" + fileName+"\"");
            ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream())
        
                    .registerWriteHandler(new SimpleRowHeightStyleStrategy((short)15,(short)15))
                    .registerWriteHandler(new SimpleColumnWidthStyleStrategy(30)) // 设置宽度
                    .build();
            WriteSheet sheetOrgTarget = EasyExcel.writerSheet(sheetNo, sheetName)
                    .head(clazz).build();
            excelWriter.write(excelList, sheetOrgTarget);
            excelWriter.finish();
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
 }