HTSQL_EXCEL Overview
The htsql_excel
package is an extension for HTSQL that adds basic
support for the Excel file format.
Installation
Install this package like you would any other Python package:
$ pip install htsql_excel
Then, enable the htsql_excel
extension when you invoke HTSQL. E.g.:
$ htsql-ctl -E htsql_excel ...
Or, in your HTSQL configuration YAML file:
htsql: db: ... htsql_excel:
Formatters
This extension adds two formatter functions to HTSQL: /:xls
and /:xlsx
.
They are tabular formatters (like /:csv
) that will output the results in
in either XLS format (the binary format used prior to Excel 2007) or XLSX (the
Office Open XML format introduced with Excel 2007).
License/Copyright
This project is released under the Apache v2 license. See the accompanying
LICENSE.rst
file for details.
Copyright (c) 2016, Prometheus Research, LLC