How to Read data from a downloaded excel to verify the contents in Playwright?

Depends on what type of file it is but most likely you will need 3rd party library for that

The file type is .xlsx. I tried using the SheetJS library but it did not work. Could you assist me in this ?

@skorp32

🤷‍♀️ don't have experience with such files, but there should be more libs to parse it

@qb1225 I used xlsx for that.

@patrickdoering Could you specify the name of the library?

npm i xlsx - https://www.npmjs.com/package/xlsx

yes, this is the exact one which I used. However, I am getting the error that File cannot be open

@patrickdoering Have you encountered such issue while trying to readFile

Nope it worked fine for me.

okay, thank you @patrickdoering

That is how my code looks like:

const workbook = xlsx.readFile(filePath);  
let workbook_sheet = workbook.SheetNames;               
let workbook_response = xlsx.utils.sheet_to_json(        
  workbook.Sheets[workbook_sheet[0]]
);
const excelString = JSON.stringify(workbook_response);