codeforequity-at / codeforequity-at/botium-core

Use exceljs instead of xlsx package for parsing xlsx files

Open
#759 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.