jqnatividad / qsv

CSVs sliced, diced & analyzed.
https://qsv.dathere.com
The Unlicense
2.46k stars 70 forks source link

`luau`: add advanced Excel writer helper functions #1474

Open jqnatividad opened 9 months ago

jqnatividad commented 9 months ago

With the to excel command, we already have a robust CSV to Excel exporter.

However, it doesn't allow you to:

Leveraging the rust_xlsxwriter crate, add Excel helper functions to the luau DSL so users can create advanced, formatted Excel spreadsheets using the qsv scripting DSL.

ondohotola commented 9 months ago

Very helpful

jqnatividad commented 9 months ago

Include a reference recipe as well that creates a formatted Excel with:

jqnatividad commented 9 months ago

Per https://github.com/DOI-DO/dcat-us/issues/131, also add a "Machine-readable" sheet as the last sheet in the workbook.

The Machine-readable sheet will have all the relevant metadata elements for the package/resource, and should hew closely to the configured DCAT profile (use DCAT-US 3.0 for the initial reference implementation).

The format of the "Machine-readable" sheet should be as follows:

After the metadata header section, a "normal", RFC-4180 compliant CSV file follows. The CSV file will be the machine-readable version of the "Data" in Sheet 1.

The recipe can then be called from Datapusher+ when populating the CKAN datastore.

Data exported from CKAN can also invoke the recipe to create an "Annotated Excel export" of a dataset.