Use exceljs instead of xlsx package for parsing xlsx files #759
Description
Describe the bug
My xlsx file has formulas to calculate dates. The xlsx package will return the calculated value when the sheet was last saved, whereas exceljs package will automatically re-evaluate the formulas
To Reproduce
Create an XLSX file and add a cell value with a formula such as ="The time right now is "&TEXT(NOW(), "hh:mm:ss")
Expected behavior
When the cell value is read, it should give me the latest time and not the time when the sheet was last updated manually
Screenshots and Log files
If applicable, add screenshots and/or logfiles to help explain your problem.
- How to get logs from Botium Box
- How to get logs from Botium Bindings
- For Botium CLI, add the --verbose command line switch
Botium Flavour:
- Botium CLI
Botium Version
- Is there an exact version where this bug is happening ?
Additional context
btw the xlsx npm package is deprecated and SheetJS recommends to use the CDN version, however, I would recommend using the exceljs package instead