在Cypress.io中如何在文本文件或Excel文件中写入变量值？

npm install --save-dev cypress-file-upload

import 'cypress-file-upload';

Cypress.Commands.add('writeToFile', (filePath, content) => {
  cy.writeFile(filePath, content);
});

cy.get('#username').invoke('val').then((username) => {
  cy.writeToFile('data.txt', username);
});

npm install --save xlsx

import XLSX from 'xlsx';

Cypress.Commands.add('writeToExcel', (filePath, sheetName, cell, content) => {
  cy.readFile(filePath).then((fileContent) => {
    const workbook = XLSX.read(fileContent, { type: 'binary' });
    const worksheet = workbook.Sheets[sheetName];
    worksheet[cell] = { t: 's', v: content };
    const updatedContent = XLSX.write(workbook, { type: 'binary', bookType: 'xlsx' });
    cy.writeFile(filePath, updatedContent, 'binary');
  });
});

cy.get('#email').invoke('val').then((email) => {
  cy.writeToExcel('data.xlsx', 'Sheet1', 'A1', email);
});