主页 / coding / 问题 / 79306058
Accepted
unlisted
Asked: 2024-12-25 00:27:15 +0800 CST

Cypress 和 Cucumber：Commands.js 函数在步骤定义中不起作用

  • 772

我在 command.js 中创建的函数在 Cucumber 步骤定义中不起作用。然而，另一个带有简单返回值的函数在同一个步骤定义中起作用。

命令.js

Cypress.Commands.add('excelData', async () => {

    const ExcelJs = require('exceljs')

    var columnArray = [];

    var workbook = new ExcelJs.Workbook()
    await workbook.xlsx.readFile('E:/Automations/Cypress/FrameworkToCucumberSpecFlow/cypress/downloads/exceldata.xlsx')
    var worksheet = workbook.getWorksheet('sampledatab')

    worksheet.eachRow((row) => {
        row.eachCell((cell) => {
            columnArray.push(cell.value)
        })
    })

    columnArray.splice(0, 1) 

    return cy.wrap(columnArray)

})

Cypress.Commands.add('TestCommandsJS', () => {
    return 'TestCommandsJS works'
})

步骤定义

When('I compare that list with the Excel specification sheet list', () => {

    cy.excelData().then(data => { //this does not work
        cy.log(data)
    })

    cy.TestCommandsJS().then(data => { //this work fine
        cy.log(data)
    })

})

任何帮助均感激不尽。

cypress

1 个回答

  1. Best Answer

    您使用的 exceljs 库是一个 Nodejs 库。

    您必须将自定义命令代码移动到任务 - 参见Cypress 任务文档。

    on('task', {
  async excelData({path, sheet}) {
    const ExcelJs = require('exceljs')
    const columnArray = []
    const workbook = new ExcelJs.Workbook()
    await workbook.xlsx.readFile(path)
    const worksheet = workbook.getWorksheet(sheet)
    worksheet.eachRow(row => {
      row.eachCell(cell => {
        columnArray.push(cell.value)
      })
    })
    return columnArray
  }
})

    然后你的测试将会使用它：

    cy.task('excelData', {
    path: 'SampleData.xlsx',   // path relative to project root
    sheet: 'SalesOrders'       // specify the sheet in test not in task 
  })
  .then(data => data.slice(0,7))  // headers
  .should('deep.eq', 
    ['OrderDate', 'Region', 'Rep', 'Item', 'Units', 'Unit Cost', 'Total'])
    • 1

相关问题