The htsql_excel
package is an extension for HTSQL that adds basic
support for the Excel file format.
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:
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).
This project is released under the Apache v2 license. See the accompanying
LICENSE.rst
file for details.
Copyright (c) 2016, Prometheus Research, LLC