codeforequity-at / codeforequity-at/botium-core
Use exceljs instead of xlsx package for parsing xlsx files
- Dominant language
- JavaScript
- Stars
- 251
- Forks
- 70
- Avg merge
- 3h 37m
- Merged PRs (30d)
- 7
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](https://botium.atlassian.net/wiki/spaces/BOTIUM/pages/29360129/Enable+Diagnostics+and+Inspect+Logs)
- [How to get logs from Botium Bindings](https://botium.atlassian.net/wiki/spaces/BOTIUM/pages/426128/Troubleshooting)
- 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
Contributor guide
Assessment
This issue has not been assessed yet.