import * as XLSX from "xlsx";
import FileSaver from 'file-saver';
function exportExcelUtil(headers, data, fileName, sheetName) {
  // 格式化数据去除无效数据
  let list = data.map(item=>{
    let obj = {};
    Object.keys(headers).forEach(key=>{
      obj[key] = item[key];
    });
    return obj;
  });
  const exportData = [
    headers,
    ...list,
  ];
  sheetName = sheetName?sheetName:"Sheet1";
  fileName = fileName?fileName:"新建xlsx工作表";
  // 注意表格上绑定id，获取dom元素
  const worksheet = XLSX.utils.json_to_sheet(exportData, { skipHeader: true });
  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, sheetName);
  const workbookOutput = XLSX.write(workbook, { bookType: "xlsx", type: "array" });
  try {
    FileSaver.saveAs(new Blob([workbookOutput], { type: 'application/octet-stream' }), fileName+".xlsx")
  } catch (e) {
    console.log(e)
  }
}

export default exportExcelUtil;