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

Assignee Loading
Time tracking Loading