search

best-practice-and-impact / gptables

Good Practice Tables - an XlsxWriter wrapper to write consistently formatted statistical tables to Excel.
http://gptables.rtfd.io
Other
35 stars 4 forks source link

ODS output #196

Open rowanhemsi opened 2 years ago

rowanhemsi commented 2 years ago

Is your feature request related to a problem? Please describe. gov.uk requires spreadsheets in ODS format. Currently gptables only outputs XLSX files.

Describe the solution you'd like Option when using write_workbook to change output file format

Additional context Underlying xlsxwriter package only writes to XLSX - would likely require writing to XLSX, reading and rewriting to ODS

rowanhemsi commented 2 years ago

pyexcel may offer a solution, but need to test whether essential accessibility criteria are correctly converted

rowanhemsi commented 2 years ago

(First mentioned in #143)

josephelliston commented 1 year ago

I second this feature request - as it currently takes much time for us to manually convert XLSX to ODS