A Python module for creating Excel XLSX files.
Project description
XlsxWriter is a Python module for creating Excel XLSX files.
XlsxWriter supports the following features:
100% compatible Excel XLSX files.
Write text, numbers, formulas, dates.
Full cell formatting.
Multiple worksheets.
Page setup methods for printing.
Merged cells.
Defined names.
Standard libraries only.
Python 2/3 support.
Here is a small example:
from xlsxwriter.workbook import Workbook # Create an new Excel file and add a worksheet. workbook = 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 highlight cell text. bold = workbook.add_format({'bold': 1}) # 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) workbook.close()
See the full documentation at https://xlsxwriter.readthedocs.org/en/latest/
The XlsxWriter module is a port of the Perl Excel::Writer::XLSX module. It is a work in progress.
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
XlsxWriter-0.0.9.tar.gz
(3.5 MB
view details)
File details
Details for the file XlsxWriter-0.0.9.tar.gz
.
File metadata
- Download URL: XlsxWriter-0.0.9.tar.gz
- Upload date:
- Size: 3.5 MB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 84e70c325a8dd80147d9be16a512076e0a6e2fec82635b661080434673a9add9 |
|
MD5 | f987ed91733eb0b8bfe917da222ddcec |
|
BLAKE2b-256 | ac2a5b2dea67a50b84c366d7053c26235ae943ba9e0dfc066325886f103d77de |