ReadExcelFile functions throws execption of childnodes of undefined after upgrading from v5.1.0 to v5.2.0 or latest
We have using read-excel-file since last 6 months and its working fine without any error The last working version without any error was v5.1.0
But when we upgraded to v5.2.0 till latest, it throws error like cannot read property childNodes of undefined.
> Cannot read property 'childNodes' of undefined
stack trace
Print to console
at <unknown> (https://localhost:44300/__cypress/runner/cypress_runner.js:140825:20)
From previous event:
at Context.task (https://localhost:44300/__cypress/runner/cypress_runner.js:140807:16)
From Your Spec Code:
at Context.eval (https://localhost:44300/__cypress/tests?p=OQ\Framework\OQ-0136-EntityGrid-02.md:15475:21)
From Node.js Internals:
TypeError: Cannot read property 'childNodes' of undefined
at findChildren (DRIVEPATH\node_modules\read-excel-file\source\xml\dom.js:17:19)
at getSheets (DRIVEPATH\node_modules\read-excel-file\source\xml\xlsx.js:87:11)
at parseProperties (DRIVEPATH\node_modules\read-excel-file\source\read\readXlsx.js:540:4)
at readXlsx (DRIVEPATH\node_modules\read-excel-file\source\read\readXlsx.js:45:23)
at readXlsxFileContents (DRIVEPATH\JuneVersion\node_modules\read-excel-file\source\read\readXlsxFileContents.js:10:18)
at <unknown> (DRIVEPATH\node_modules\read-excel-file\source\read\readXlsxFileNode.js:15:23)
at processTicksAndRejections (internal/process/task_queues.js:93:6)
Attached is the Sheet which we are trying to read. Its working fine in v5.1.0 but not in any of the subsequent version.
I found the change in the folder structure and logical files between the v5.1.0 and v5.2.0 under commonjs folder.
A guide or help to fix this would be appreciated
Regards Prashant kankhara PhraseEntityList.xlsx