node.js - Exceljs 返回 'VERDADERO' 而不是 'TRUE'

Question

我正在创建一个使用导入和导出 excel 文件的应用程序，我需要 excel 以英语返回，TRUE而是FALSE在现场返回VERDADERO，有一种方法可以用英语导出所有文件，谢谢FALSOacceptTerms

async function generateExcel(req, res, next) {
  try {
    const ingresantes = await Ingresante.aggregate([
      {
        $project: {
          documentNumber: 1,
          codigo: 1,
          apellidos: 1,
          nombres: 1,
          email: 1,
          acceptTerms: 1,
        },
      },
    ]);

    var workbook = new Excel.Workbook();
    var worksheet = workbook.addWorksheet("subida");

    worksheet.columns = [
      { header: "DNI", key: "documentNumber", width: 10 },
      { header: "CODIGO", key: "codigo", width: 10 },
      { header: "APELLIDOS", key: "apellidos", width: 20 },
      { header: "NOMBRES", key: "nombres", width: 20 },
      { header: "CORREO", key: "email", width: 35 },
      { header: "ESTOY_CONFORME", key: "acceptTerms", width: 25 },
    ];

    ingresantes.map((data, index) => {
      data.nro = ++index;
      worksheet.addRow(data);
    });

    worksheet.getRow(1).eachCell((cell) => {
      cell.font = { bold: true };
    });

    var tempFilePath = tempfile(".xlsx");

    await workbook.xlsx.writeFile(tempFilePath);
    await res.status(200).sendFile(tempFilePath);
  } catch (err) {
    next(err);
  }
}

标签： node.jsexcelmongodbmongooseexceljs