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

Make intermediate file an XLSX instead of CSV #120

Open
ursjoss opened this issue Oct 4, 2023 · 0 comments
Open

Make intermediate file an XLSX instead of CSV #120

ursjoss opened this issue Oct 4, 2023 · 0 comments

Comments

@ursjoss
Copy link
Owner

ursjoss commented Oct 4, 2023

This will resolve a few open issues:

Pros:

  • current problem that date is expected to be dd.mm.yyyy. dd.mm.yy has to be manually corrected before continuing the process
  • diffing on file level is possible, but once saved as CSV from Excel, next to the data format, also the number format is contorted, e.g. 0.0 is saved as 0, depending on the number format, the digits after the decimal point may even be rounded, what not only obfuscates the diff but may even change the content.

Cons:

  • diffing on file level will not be possible

Steps:

  • have the prepare task create an XLSX instead of CSV
  • have the export task expect an XSLX istead of CSV

If it is cheap to support both CSV and XLSX (with XLSX as default), prefer that.

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