【EasyExcel】导出

重启人生之......

已于 2024-01-20 11:19:19 修改

阅读量325

点赞数 11

分类专栏：日常小bug 文章标签： excel easyui

于 2024-01-18 20:28:07 首次发布

本文链接：https://blog.csdn.net/m0_51232873/article/details/135682920

版权

日常小bug 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

本文详细说明了如何在SpringBoot应用中使用EasyExcel进行CSV数据导出，支持多表格和嵌入ECharts图表，前端通过axios进行请求并下载文件。

摘要由CSDN通过智能技术生成

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.metadata.Sheet;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

@RestController
public class ExportController {

    @PostMapping("/export")
    public void export(HttpServletResponse response, @RequestBody Task task) throws IOException {
        List<Task1> List1 = task.getTask1List();
        List<Task2> List2 = task.getTask2List();

        String fileName = "exportedData";
        String sheetName = "Data";

        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");

        ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build();
        Sheet sheet = new Sheet(1, 0);
        sheet.setSheetName(sheetName);

        // Add Task, Head, and Line data to the same sheet
        excelWriter.write(List1 , sheet);
        excelWriter.write(List12, sheet);

        excelWriter.finish();

        // Send success message to frontend
        response.getWriter().write("Export successful");
    }
}

Frontend (JavaScript/Vue.js):

handleExport() {
  this.$axios.post('system/export', this.queryParams, { responseType: 'blob' })
    .then(response => {
      const blob = new Blob([response.data], { type: 'application/vnd.ms-excel' })
      const link = document.createElement('a')
      link.href = window.URL.createObjectURL(blob)
      link.download = `Task_${new Date().getTime()}.xlsx`
      link.click()
      this.$message.success('Export successful')
    })
    .catch(error => {
      this.$message.error('Export failed')
    })
}

【EasyExcel 教程】详解填充Excel -- 填充_forcenewrow-CSDN博客

easypoi模板导出、一张sheet有多个不同表格、带一张或多张echars图表_easypoi实现多个table表格-CSDN博客 springboot+easypoi模板导出Excel 动态表头+多表格（一个sheet）_springboot导出excel文件时如何设置成动态表头-CSDN博客