将数据库中查询的结果导出为Excel

最新推荐文章于 2024-02-22 15:52:10 发布

狗狗狗狗狗乐啊

最新推荐文章于 2024-02-22 15:52:10 发布

阅读量587

点赞数 12

分类专栏：工作经验总结文章标签：数据库 excel

本文链接：https://blog.csdn.net/weixin_44122062/article/details/136021396

版权

工作经验总结专栏收录该内容

18 篇文章 0 订阅

订阅专栏

引用：

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import cn.afterturn.easypoi.excel.entity.enmus.ExcelType;
import cn.hutool.core.lang.Assert;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.stereotype.Service;

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

代码：

    @Override
    public void exportChangeList(AnalysisVO analysis, HttpServletResponse response) {
        List<AnalysisVO> records = this.changeList(new Page<>(1, -1), analysis).getRecords();
        Assert.notEmpty(records, () -> new ServiceException("无导出数据"));
        ExportParams exportParams = new ExportParams("变更列表（单位:个）", "变更列表", ExcelType.XSSF);
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, AnalysisExcel.class, BeanUtil.copy(records, AnalysisExcel.class));
        try (OutputStream out = response.getOutputStream()) {
            response.setHeader("Content-Disposition", "attachment; filename=changeList.xlsx");
            response.setContentType("application/vnd.ms-excel");
            workbook.write(out);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

实体类：

import cn.afterturn.easypoi.excel.annotation.Excel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class AnalysisExcel {
    @Excel(name = "序号", format = "isAddIndex")
    private Integer index;
    @ApiModelProperty(value = "主管单位ID")
    private String budgetManageUnitId;
    @Excel(name = "主管单位名称", width = 60)
    private String budgetManageUnitName;
    @Excel(name = "新建类", width = 25)
    private String newClass;
    @Excel(name = "运维类", width = 25)
    private String operationsClass;
    @Excel(name = "服务类", width = 25)
    private String serviceClass;
    @Excel(name = "排名", width = 30)
    private String rank;
}