Vue导出Excel表格并把指定内容除以60和除以3600，保留两位小数 设置默认日期（年月日时分秒）

定义两个单选框

<div style="display: flex;align-items: center;margin-left: 80px">
   <p style="margin-right: 20px">单位</p>
      <el-radio v-model="radios" label="1" @change="selTimeHours">时</el-radio>
      <el-radio v-model="radios" label="2" @change="selTimeMinutes">分</el-radio>
</div>

创建导出按钮

 <div class="buttonBox" style="margin-bottom: 10px;">
   <div>
      <div class="chooseButton searchButton" @click="exportClick">
            <i class="el-icon-download"></i>导出
      </div>
   </div>
 </div>

创建表格

<el-table ref="singleTable" :data="selectPageDayList" highlight-current-row border style="width: 100%;" height="100%" :header-cell-style="{'background-color': '#45494f','color': '#ffffff',}">
   <el-table-column header-align="center" align="center" label="序号" type="index" width="50"></el-table-column>
     <el-table-column prop="createTime" :label="this.radios=='1'?'运转时长(时)':'运转时长(分)'" align="left">
        <template slot-scope="scope">
           <span style="font-size: 16px;">               
           {{parseFloat(updatatime(scope.row.loadTime)).toFixed(2)}} </span>
        </template>
      </el-table-column>

     <el-table-column prop="lifeAlarmTime" :label="this.radios=='1'?'异常停止(时)':'异常停止(分)'" align="left">
        <template slot-scope="scope">
           <span style="font-size: 16px;"> 
            {{parseFloat(updatatime(scope.row.shutdownTime)).toFixed(2)}}
           </span>
        </template>
     </el-table-column>
</el-table>

导出

<exportMes :exportTitle="exportTitle" :exportData="tableDataTreeTimeExport" :exportList="exportList" style="width: 100%;height: 100%" ref="exportBox"></exportMes>

JS

  export default { 
    data() {
      return {
        exportTitle:'',
        tableDataTreeTime: [],
        tableDataTreeTimeExport: [],
        pageCount: 1,
        pageSize: 10,
        selectPageDayList: [],
        selectPageList: [],
        Readytime: '', // 时间月
        value1: [], //时间日
        radio: '1', // 期间
        radiosss: '1', // 单位
        radios: '1',
        timeChange: '1', // 用来判断日期格式
        item: '',
        typeNext: true, // 是否包含当前时间
        exportList: [{
          column: 'loadTimeNew',
          title: '运转时长(时)',
          headerAlign: 'center',
          align: 'center',
          width: '200px'
        }, {
          column: 'shutdownTime',
          title: '异常停止(时)',
          headerAlign: 'center',
          align: 'center',
          width: '200px'
        }],
        searchData: {

          beginTime: "2022-04-07 08:00:00",
          endTime: "2022-04-09 02:00:00",
          id: 0,
          type: 2,
          next: true,
          sort: "ASC",
          sortName: "activation",
        },
        value: '',
        // 排序默认
        tableDataTreeTime: [{
          warehouseName: '1'
        }]
      }
    },
}

 methods: {
      // 设置默认日期
      defaultDateMonth() {
        //获取新的时间(2019.4.12）
        let date = new Date()
        //获取当前时间的年份转为字符串
        let year = date.getFullYear().toString() //'2019'
        //获取月份，由于月份从0开始，此处要加1，判断是否小于10，如果是在字符串前面拼接'0'
        let month = date.getMonth() + 1 < 10 ? '0' + (date.getMonth() + 1).toString() : (date.getMonth() + 1)
          .toString() //'04'
        //获取天，判断是否小于10，如果是在字符串前面拼接'0'
        let da = date.getDate() < 10 ? '0' + date.getDate().toString() : date.getDate().toString() //'12'
        //获取时
        let hour = date.getHours() < 10 ? '0' + date.getHours().toString() : date.getHours().toString()
        //获取分
        let minute = date.getMinutes() < 10 ? '0' + data.getMinutes().toString() : date.getMinutes().toString()
        //获取秒
        let second = date.getSeconds() < 10 ? '0' + data.getSeconds().toString() : date.getSeconds().toString()
        //字符串拼接，开始时间，结束时间
        let end = year + '-' + month + '-' + da + ' ' + hour + ':' + minute
        let beg = year + '-' + month + '-01' + ' ' + '08' + ':' + '00'
        this.value1 = [beg, end] //将值设置给插件绑定的数据
        let end1 = year + '-' + month //当天'2019-04-12'
        let beg1 = year + '-' + month //当月第一天'2019-04-01'
        this.Readytime = [beg1, end1] //将值设置给插件绑定的数据
      },

      // 获取时间
      getTime() {
        file.selectTimee().then((response) => {
          const data = response.data;
          if (data.code == "1") {
            this.value1.push(data.data.beginTime, data.data.endTime)
          }
        }).catch((response) => {
          console.log(response)
        })
      },
      //获取时间的默认值
      getDate() {
        let start = this.Fungetdate(0) // 7天前
        let end = this.Fungetdate(0) // 当前时间
        this.dateValue.push(start, end)
        console.log('aaaa', start)
        this.Readytime = this.dateValue
        this.value1 = this.dateValue
        this.dyTime = this.dateValue //  当前时间
      },
      // 点击单选框 月  1
      selLables(val) {
        console.log('月', val)
        this.timeChange = '1'
      },
      // 点击单选框  日 2
      selLable(val) {
        console.log('日', val)
        this.timeChange = '2'
        // console.log(this.value1)
      },

      //点击单选框 时
      selTimeHours() {
        this.exportList[2].title = '运行时长(时)'
        this.exportList[3].title = '异常停止(时)'
        this.excle();
      },
      //点击单选框 分
      selTimeMinutes() {
        this.exportList[2].title = '运行时间(分)'
        this.exportList[3].title = '异常停止(分)'
        this.excle();
      },
      exportClick() {
        this.$refs.exportBox.setExportExcel();
      },

      changeTime(e) {
        this.$forceUpdate()
      },
      search() {
        if (this.radio == '1') {
          this.searchData.beginTime = this.Readytime[0]
          this.searchData.endTime = this.Readytime[1]
        } else {
          this.searchData.beginTime = this.value1[0] + ':00'
          this.searchData.endTime = this.value1[1] + ':00'
        }
        let param = {
          pageNum: 1,
          pageSize: this.pageSize,
        }
        this.searchPage(param)
      },
      searchPage(param) {
        //请求检索条件
        var dataParam = this.searchData;
        var newParam = Object.assign(param, dataParam);
        if (this.radio == 1) {
          kpi.selectPage(newParam).then((response) => {
            const data = response.data;
            if (data.code == "1") {
              this.selectPageDayList = data.data.records;
              this.pageNum = data.data.current;
              this.pageCount = data.data.total;
              this.$refs['pageModel'].setCurrent(this.pageNum);
            }
          }).catch((response) => {
            console.log(response)
          });
        } else {
          kpi.selectPageDay(newParam).then((response) => {
            const data = response.data;
            if (data.code == "1") {
              this.selectPageDayList = data.data.records;
              this.pageNum = data.data.current;
              this.pageCount = data.data.total;
              this.$refs['pageModel'].setCurrent(this.pageNum);
            }
          }).catch((response) => {
            console.log(response)
          });
        }
        this.selectExcel(newParam);
      },
      // 调用Excle接口
      selectExcel(param) {
        if (this.radio == 1) {
          kpi.selectExcel(param).then((response) => {
            const data = response.data;
            if (data.code == "1") {
              this.tableDataTreeTimeExport = data.data;
              this.excle();
            }
          }).catch((response) => {
            console.log(response)
          })
        } else {
          kpi.selectDayExcel(param).then((response) => {
            const data = response.data;
            if (data.code == "1") {
              this.tableDataTreeTimeExport = data.data;
              this.excle();
            }
          }).catch((response) => {
            console.log(response)
          })
         }
        },
        // 循环遍历数组  /3600=时  /60=分（仅限该项目） .toFixed()保留小数  括号内写小数位数
      excle() {
        if (this.radios == 1) {
          for (var i = 0; i < this.tableDataTreeTimeExport.length; i++) {
            this.tableDataTreeTimeExport[i].loadTimeNew =(this.tableDataTreeTimeExport[i].loadTime / 3600).toFixed(2)
            this.tableDataTreeTimeExport[i].shutdownTime =(this.tableDataTreeTimeExport[i].shutdownTime / 3600).toFixed(2)
          }
        } else {
          for (var i = 0; i < this.tableDataTreeTimeExport.length; i++) {
             this.tableDataTreeTimeExport[i].loadTimeNew =(this.tableDataTreeTimeExport[i].loadTime / 60).toFixed(2)
             this.tableDataTreeTimeExport[i].shutdownTime =(this.tableDataTreeTimeExport[i].shutdownTime / 60).toFixed(2)
          }
        }
      },
      newMes(data) {
        this.searchData.type = data.type;
        this.searchData.id = data.id;
        this.search();
      },

      updatatime(time) {
        if (this.radios == '1') {
          return time / 3600000
        } else {
          return time / 60000
        }
      }
    },
    created() {
      // this.selectPage();
      this.defaultDateMonth();
      // this.getTime();
      this.search();
      // this.timer = setInterval(() => {
      //   setTimeout(() => {
      //     this.search()
      //   }, 0)
      // }, 5000)
    },

自用   入行不久  欢迎大佬们吐槽和传授经验  谢谢大家