这就是我使用JSON数据创建example.xlsx文件的方法。

const { readFile, writeFile } = require('fs').promises;
const { json2csvAsync } = require('json-2-csv');

async function writeCSVFile (fileName, data) {
  await writeFile(fileName, data, 'utf8');
}

export const createExcel = async (fileName = '', dataToWrite: any) => {
  try {
    const data = JSON.parse(dataToWrite)
    const csv = await json2csvAsync(data);
    await writeCSVFile(fileName, csv);
    console.log(`Successfully converted ${fileName}!`);
  }
  catch (err) {
    console.log(err);
    return [];
  }
}

如何从不同文件调用函数：

const JsonData = [
      {
      "email": "abc@gmail.com",
      "industry":"IT",
      "role": "Developer",
      "firstName": "Shubham",
      "lastName": "Verma",
      "title": "Software Engineer",
      "country": "India"
      },
      {
      "email": "XYG@gmail.com",
      "industry":"IT",
      "role": "Developer",
      "firstName": "Ankit",
      "lastName": "Kumar",
      "title": "Software Engineer",
      "country": "India"
      }
   ];



 const fileName = 'result.xlsx';
 const fileResult = await createExcel(fileName, JSON.stringify(JsonData));