SpringBoot+Vue实现导入导出_springboot+vue如何实现导入导出-优快云博客

本文链接：https://blog.youkuaiyun.com/YYYzic/article/details/131899594

文章介绍了在JavaWeb环境中使用Hutool、ApachePOI和EasyExcel库进行Excel数据的导出和导入。后端代码展示了如何创建Excel文件，设置列宽，处理不同浏览器的文件名编码问题，以及将数据写入Excel。前端部分则包含导出和导入功能的按钮触发及操作反馈。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

pom依赖：

<!-- hutool -->
<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-all</artifactId>
    <version>5.7.20</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

<!-- 导出数据的依赖-->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>2.2.6</version>
</dependency>

utils工具类：

package com.example.boot.utils;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;

import org.apache.poi.ss.usermodel.Workbook;
import javax.servlet.ServletOutputStream;
import java.io.*;

/**
* @ClassName EasyExcelUtil
* @Description TODO
* @Author gwq
* @Date 2023/3/8 18:36
**/
public class ExportEncodeUtil {

/**
* @Author gwq
* @Description 导出
* @Date 2023/4/12 20:52
* @Return void
* @param request
* @param response
* @param sheetName
* @param workbook
*/
public static void HeaderCode(HttpServletRequest request, HttpServletResponse response, String sheetName, HSSFWorkbook workbook) throws IOException {
// 针对IE或者以IE为内核的浏览器：
String userAgent = request.getHeader("User-Agent").toLowerCase();
String fileName = sheetName + ".xls";
if (userAgent.contains("msie") || userAgent.contains("trident")) {
fileName = URLEncoder.encode(fileName, "UTF-8");
} else {
// 非IE浏览器的处理：
fileName = new Strin