java-http导出工具类

最新推荐文章于 2024-07-08 14:58:49 发布

点、滴

最新推荐文章于 2024-07-08 14:58:49 发布

阅读量89

点赞数 2

文章标签： java http 开发语言

本文链接：https://blog.csdn.net/qq_42811766/article/details/138162104

版权

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.metadata.style.WriteCellStyle;
import com.alibaba.excel.write.style.HorizontalCellStyleStrategy;
import org.apache.poi.ss.usermodel.HorizontalAlignment;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

public class ExportUtils {
    public static void export(HttpServletResponse response, String sheetName, Class<?> headClass, List data){
        //                  设置头居中
        WriteCellStyle head = new WriteCellStyle();
        head.setHorizontalAlignment(HorizontalAlignment.CENTER);
//                  内容策略
        WriteCellStyle conetn = new WriteCellStyle();
//                  设置水平居中
        conetn.setHorizontalAlignment(HorizontalAlignment.CENTER);
        HorizontalCellStyleStrategy horiz = new HorizontalCellStyleStrategy(head, conetn);
        try {
            EasyExcel.write(response.getOutputStream())
                    .registerWriteHandler(horiz)
                    .sheet(sheetName)
                    .head(headClass)
                    .doWrite(data);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }
}