XlsxWriter is a Python module for writing files in the Excel 2007+ XLSX file format.
XlsxWriter can be used to write text, numbers, formulas and hyperlinks to multiple worksheets and it supports features such as formatting and many more, including:
100% compatible Excel XLSX files.
Full formatting.
Merged cells.
Defined names.
Charts.
Autofilters.
Data validation and drop down lists.
Conditional formatting.
Worksheet PNG/JPEG images.
Rich multi-format strings.
Cell comments.
Integration with Pandas.
Textboxes.
Memory optimisation mode for writing large files.
It supports Python 2.5, 2.6, 2.7, 3.1, 3.2, 3.3, 3.4, Jython and PyPy and uses standard libraries only.
Here is a simple example:
import xlsxwriter
# Create an new Excel file and add a worksheet.
workbook = xlsxwriter.Workbook('demo.xlsx')
worksheet = workbook.add_worksheet()
# Widen the first column to make the text clearer.
worksheet.set_column('A:A', 20)
# Add a bold format to use to highlight cells.
bold = workbook.add_format({'bold': True})
# Write some simple text.
worksheet.write('A1', 'Hello')
# Text with formatting.
worksheet.write('A2', 'World', bold)
# Write some numbers, with row/column notation.
worksheet.write(2, 0, 123)
worksheet.write(3, 0, 123.456)
# Insert an image.
worksheet.insert_image('B5', 'logo.png')
workbook.close()
See the full documentation at: http://xlsxwriter.readthedocs.org
Release notes: http://xlsxwriter.readthedocs.org/changes.html
1 maintainer
Release files for xlsxwriter 0.7.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| XlsxWriter-0.7.4.tar.gz | 232.3 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| XlsxWriter-0.7.4-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size:365.5 kB
Release files / XlsxWriter-0.7.4.tar.gz
| Download URL | XlsxWriter-0.7.4.tar.gz |
|---|---|
| Size | 232.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e3192763b377a588fc06113836cf74a565926168929e55ba451baa684e857b62
|
|
BLAKE2b-256 checksum How to use checksums |
5d5b2de2063c74bac22da8c23cbe2bc1ce9833c414b996fafa7da5e256f13ce3
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / XlsxWriter-0.7.4-py2.py3-none-any.whl
| Download URL | XlsxWriter-0.7.4-py2.py3-none-any.whl |
|---|---|
| Size | 133.2 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
bd4d754ece38306d62b87bfa307df472ec820b75222f4fc0658ec5ce8f5383a3
|
|
BLAKE2b-256 checksum How to use checksums |
e5b9089e8f43b82e0b09f44f9ee2dbc6c482b5601672a9867026c21884b15130
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
