Save pyexcel data with XlsxWriter, while retaining good formatting.
Project description
pyexcel-xlsxwx
Save pyexcel data with XlsxWriter, while retaining good formatting.
Features
- Allow setting column widths and word wrap.
- A package for reading data is not included, please see
pyexcel
's plugins here.
Installation
$ pip install pyexcel-xlsxwx
Note that pyexcel
is not a dependency.
Usage
>>> import pyexcel_xlsxwx
>>> data = OrderedDict() # from collections import OrderedDict
>>> data.update({"Sheet 1": [[1, 2, 3], [4, 5, 6]]})
>>> data.update({"Sheet 2": [["row 1", "row 2", "row 3"]]})
>>> pyexcel_xlsxwx.save_data("your_file.xlsx", data)
You can also define a custom config via:
>>> pyexcel_xlsxwx.save_data("your_file.xlsx", data, config=config)
Where config can be dictionary or path to YAML file.
The default YAML config is:
workbook:
constant_memory: true
strings_to_numbers: false
strings_to_formulas: false
strings_to_urls: true
worksheet:
_default:
freeze_panes: A2
# column_width: 30
smart_fit: true
max_column_width: 30
format:
_default:
valign: top
text_wrap: true
column_width
can also accept a list and a dictionary where key indicates the column.
row_height
can also be set the same way.
To cancel out freeze_panes
, try:
>>> pyexcel_xlsxwx.save_data("your_file.xlsx", data, config={'worksheet': {'_default': {'freeze_panes': None}}})
The settings will merge (thanks to https://stackoverflow.com/questions/20656135/python-deep-merge-dictionary-data), so that the other formattings won't be lost.
Related projects
- pyexcel-openpyxlx - export the styles for XlsxWriter.
- pyexcel-export - operates using OpenPyXL, which seeming has bad word wrap support. However, the formatting can be well preserved.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pyexcel-xlsxwx-0.1.7.tar.gz
(4.5 kB
view hashes)
Built Distribution
Close
Hashes for pyexcel_xlsxwx-0.1.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 42ca4ddbcab02f0b4180956ac51c99fa34f2fb9cfbb94e80a2000885afcddb8a |
|
MD5 | 99bb63c24e2b5267765a746f8dfc783f |
|
BLAKE2b-256 | f64a4a8049e00b4e60b3b18e3c9e6caad6308333d15f84d13fa760ab1818e7c9 |