-
Notifications
You must be signed in to change notification settings - Fork 70
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
luau
: add advanced Excel writer helper functions
#1474
Comments
Very helpful
|
Include a reference recipe as well that creates a formatted Excel with:
|
Per DOI-DO/dcat-us#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. |
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.
The text was updated successfully, but these errors were encountered: