makexlsx – make XLSX spreadsheet from tabular data files
Do you often import CSV files to Excel, and find yourself doing the same mouse-clicky nonsense every time to make it look nice? Would you like all that fiddling with column widths, autofiltering, text wrapping and centering to just happen by magic? Yes, so would I. Which is why I wrote this:
It takes one or more tabular data files (not just CSV, but any format that tablib will accept) and produces an XLSX workbook with one table per sheet.
If a table header is present, it’s made bold, the header line is frozen, and autofiltering is applied to all the columns.
Wrapping is applied to any columns that have line breaks in their values, or lines beyond a certain (user-defined) length.
All numeric columns are right-justified. Non-numeric columns are centred if their width is below a certain (user-defined) size, otherwise they are left-justified.
It uses the amazing xlsxwriter package to do all the output.
1 maintainer
Metadata
1 maintainer
Release files for makexlsx 0.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| makexlsx-0.1.tar.gz | 7.4 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| makexlsx-0.1-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details |
Total release size: 13.9 kB
Release files / makexlsx-0.1.tar.gz
| Download URL | makexlsx-0.1.tar.gz |
|---|---|
| Size | 7.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
dbb3470a36dd966900a9665c2e7fd30b0ee18b87b18603f325b0a3f8ca071061
|
|
BLAKE2b-256 checksum How to use checksums |
b1163861d3a3c2214acfa76a19e8192d27561307d1634d4c5a791f93b4226e42
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.0 CPython/3.7.3
|
Release files / makexlsx-0.1-py2.py3-none-any.whl
| Download URL | makexlsx-0.1-py2.py3-none-any.whl |
|---|---|
| Size | 6.5 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
e03c95f9fe1b8fdd35eb1777387976a91063ab76625cde6871ea3f739fe99710
|
|
BLAKE2b-256 checksum How to use checksums |
396b3bdccfb9da23e6232d55a4e875ae6116d41c6a70ccf820e8051cc9ca356b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.0 CPython/3.7.3
|
