前端js通过xlsx组件实现将json数据处理成表格并导出成excel数据

import XLSX from 'xlsx'
function parseJsonToTable(jsonData , tableNameT , tableNameChinaT) {
  const tableData = [];
  const rowData = ['表名','中文表名','字段名','中文字段名','字段表对应编码'];
  tableData.push(rowData);
  for (let key of Object.keys(jsonData)) {
    let jsonDatum = jsonData[key]; //获取每个对象
    // 获取数组中的对象
    for (let arr in jsonDatum) {
      let obj = jsonDatum[arr]
      const item = obj;
      if (item.name==undefined){
        continue;
      }
      const rowData = [tableNameT  , tableNameChinaT , item.name==undefined?"-":item.name, item.label==undefined?"-":item.label, item.code==undefined?"-":item.code];
      // const rowData = [1,2,3];
      tableData.push(rowData);
    }
  }
  return tableData;
}

function exportToExcel(tableData, fileName) {
  const ws = XLSX.utils.aoa_to_sheet(tableData);
  const wb = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(wb, ws, "Sheet1");
  XLSX.writeFile(wb, fileName);
}
for (let i=0 ; i <tableName.length ; i ++){
  const tableData = parseJsonToTable(context[i] , tableName[i] ,tableNameChina[i]);
  exportToExcel(tableData, tableName[i]+'.xlsx');
}