Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Use exceljs instead of xlsx package for parsing xlsx files #759

Open
nabeel-ibrahim opened this issue Jun 30, 2023 · 0 comments
Open

Use exceljs instead of xlsx package for parsing xlsx files #759

nabeel-ibrahim opened this issue Jun 30, 2023 · 0 comments

Comments

@nabeel-ibrahim
Copy link

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.

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant