若依框架，导入功能实现

前端代码实现：

<!-- 导入对话框 -->
    <el-dialog :title="upload.title" :visible.sync="upload.open" width="400px" append-to-body>
      <el-upload
        ref="upload"
        :limit="1"
        accept=".xlsx, .xls"
        :headers="upload.headers"
        :action="upload.url "
        :disabled="upload.isUploading"
        :on-progress="handleFileUploadProgress"
        :on-success="handleFileSuccess"
        :auto-upload="false"
        drag
      >
        <i class="el-icon-upload"></i>
        <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
        <div class="el-upload__tip text-center" slot="tip">
          <span>仅允许导入xls、xlsx格式文件。</span>
          <el-link type="primary" :underline="false" style="font-size:12px;vertical-align: baseline;" @click="importTemplate">下载模板</el-link>
        </div>
      </el-upload>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitFileForm">确 定</el-button>
        <el-button @click="upload.open = false">取 消</el-button>
      </div>
    </el-dialog>

 方法以及属性

import { getToken } from "@/utils/auth"; 


data() {
    return {
    upload: {
        // 是否显示弹出层
        open: false,
        // 弹出层标题
        title: "",
        // 是否禁用上传
        isUploading: false,
        // 设置上传的请求头部
        headers: { Authorization: "Bearer " + getToken() },
        // 上传的地址，请求地址
        url: process.env.VUE_APP_BASE_API + "/~/~/~"
      }
}
}


methods：{
    //下载模板
 importTemplate() {
      this.download('/admin/terminalbox/downloadTemplate', {
      }, `终端箱导入表${new Date().getTime()}.xlsx`)
    },
     /** 导入按钮操作 */
    handleImport() {
      this.upload.title = "用户导入";
      this.upload.open = true;
    },
    // 文件上传中处理
    handleFileUploadProgress(event, file, fileList) {
      this.upload.isUploading = true;
    },
    // 文件上传成功处理
    handleFileSuccess(response, file, fileList) {
      this.upload.open = false;
      this.upload.isUploading = false;
      this.$refs.upload.clearFiles();
      this.$alert("<div style='overflow: auto;overflow-x: hidden;max-height: 7                        
      0vh;padding: 10px 20px 0;'>" + response.msg + "</div>", "导入结果", { 
      dangerouslyUseHTMLString: true 
    });
      this.getList();
    },
    // 提交上传文件
    submitFileForm() {
      this.$refs.upload.submit();
    }
}

 auth.js

import Cookies from 'js-cookie'

const TokenKey = 'Admin-Token'

const ExpiresInKey = 'Admin-Expires-In'

export function getToken() {
  return Cookies.get(TokenKey)
}

export function setToken(token) {
  return Cookies.set(TokenKey, token)
}

export function removeToken() {
  return Cookies.remove(TokenKey)
}

export function getExpiresIn() {
  return Cookies.get(ExpiresInKey) || -1
}

export function setExpiresIn(time) {
  return Cookies.set(ExpiresInKey, time)
}

export function removeExpiresIn() {
  return Cookies.remove(ExpiresInKey)
}

 接口：

    //导入
    @PostMapping("/importBox")
    @Transactional
    public AjaxResult importBox(MultipartFile file) throws Exception
    {
        
        ExcelUtil<TerminalBoxImport> util = new ExcelUtil<TerminalBoxImport>    (TerminalBoxImport.class);
        List<TerminalBoxImport> userList = util.importExcel(file.getInputStream());
        for (TerminalBoxImport c:userList) {
            //插入操作
            cuuTerminalBoxService.importBox(c);
        }
        return AjaxResult.success();
    }
    //下载模板
    @PostMapping("/downloadTemplate")
    public void importTemplate(HttpServletResponse response) throws IOException
    {
        ExcelUtil<TerminalBoxImport> util = new ExcelUtil<TerminalBoxImport>(TerminalBoxImport.class);
        util.importTemplateExcel(response, "xxx数据");
    }