导出到Excel,纠正fixed时,造成的列反复问题;
入参:表对象id,导出时的文件名称
须要援用xlsx插件;

function sexportExcel(sid, sname){  // 设置以后日期  let time = new Date();  let year = time.getFullYear();  let month = time.getMonth() + 1;  let day = time.getDate();  let name = sname + "  " + year + "" + month + "" + day;  let xlsxParam = { raw: true };//转换成excel时,应用原始的格局  let table = document.querySelector(sid);  // 因为element-ui的表格的fixed属性导致多出一个table,会下载反复内容,这里删除掉  var fix = table.querySelector('.el-table__fixed');  let wb ;//mytable为表格的id名  if (fix) {    wb = XLSX.utils.table_to_book(table.removeChild(fix),xlsxParam);    table.appendChild(fix);  } else {    wb = XLSX.utils.table_to_book(table,xlsxParam);  }    let wbout = XLSX.write(wb, {    bookType: "xlsx",    bookSST: true,    type: "array",  });  try {    FileSaver.saveAs(      new Blob([wbout], { type: "application/octet-stream" }),      name+".xlsx"    );  } catch (e) {    if (typeof console !== "undefined") console.log(e, wbout);  }  return wbout;}