CLASS/CLASS1/miniprogram/pages/test2/test2.js

Page({
    clickBtn() {
    let that = this;
    wx.chooseMessageFile({
      count: 1,
      type: 'file',
      success: res => {
        wx.showLoading({
          title: '正在上传',
        });
        let filePath = res.tempFiles[0].path;
        console.log("选择execl成功", filePath);
        that.clearDatabase(filePath);
      }
    });
  },
    
    clearDatabase(filePath) {
    const db = wx.cloud.database({
      env: 'fzu-rollcall-system-7c9tbd0e8c2b'
    });
    const stu = db.collection('users'); // 替换为你的集合名称
    stu.where({
      _id: db.command.exists(true)
    }).remove().then(res => {
      console.log('删除成功');
      this.setData({
        number: ''
      });
      this.cloudFile(filePath);
    }).catch(err => {
      console.log('删除失败', err); // 失败提示错误信息
    });
  },
  
    cloudFile(path){
      let that = this
      wx.cloud.uploadFile({
        cloudPath:"xueshemingdan.xlsx",
        filePath: path,
        success: res=>{
          wx.hideLoading()
          console.log("上传成功",res.fileID)
          that.jiexi(res.fileID)
        },
        fail: err=>{
          console.log("上传失败",err)
        }
      })
    },
  
    jiexi(fileId){
      wx.cloud.callFunction({
        name:"excel",
        data:{
          fileID: fileId
        },
        success(res) {
          console.log("success",res)
        } ,
        fail(res)
        {
          console.log("failed",res)
        }
      })
    }
  });