An HTSQL extension that adds basic Excel support.
Project description
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 licensed under the GNU Affero General Public License, version 3. See the accompanying LICENSE.rst file for details.
Copyright (c) 2016, Prometheus Research, LLC
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file htsql_excel-0.1.2.tar.gz
.
File metadata
- Download URL: htsql_excel-0.1.2.tar.gz
- Upload date:
- Size: 16.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: Python-urllib/2.7
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8fc624f5cbb0498d218afe784e7949ef80149cad4e6e04fe28bead5a34484ca5 |
|
MD5 | bc38628393b181356d12ecdb0763258e |
|
BLAKE2b-256 | 46ad4f339a67463db10409027a0b0d25ef5d6926d5396efce49c88325f369af1 |