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