how to write data for excel file in cypress?

Question

I'm new to Cypress, I want to know how to write data to xlsx file, I tried writing this way but it can't open xlsx file.

cy.writeFile('cypress/fixtures/DataTest/login_result.xlsx', '\nUsername : ' + Username + '\n' + '\nPassword : ' + Password + '\n' + '\nExpectedResult : ' + ExpectedResult + '\n' + '\nActualResult : ' + Asresult + '\n' + '\nResult :' + result + '\n').as('writeXlsxFile')

xlsx file is not just a plain text, so you likely need some JS library to do the hard work for you. At some places, node-xlsx library is mentioned, so perhaps you can have a look into it. — pavelsaman
– pavelsaman, Commented Oct 26, 2021 at 7:43

Suraj Rao · Accepted Answer · 2022-08-16 06:39:14Z

1

Consider the extension of the Excel file as xls. For example, in the code below, the word Hello is written in the Excel file

cy.writeFile('cypress/fixtures/Test.xls', 'Hello','UTF-8')

edited Aug 16, 2022 at 6:39

Suraj Rao

29.7k11 gold badges96 silver badges104 bronze badges

answered Aug 16, 2022 at 6:38

Somayyeh Mehrabadi

211 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to write data for excel file in cypress?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related