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.
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.8.tar.gz
(3.5 MB
view details)
File details
Details for the file XlsxWriter-0.0.8.tar.gz
.
File metadata
- Download URL: XlsxWriter-0.0.8.tar.gz
- Upload date:
- Size: 3.5 MB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1a6c684654d4cdba81b1569ebb567784f766418a59ed4883c920e88dad04d00a |
|
MD5 | 8624515093e6970470713d00ea024e05 |
|
BLAKE2b-256 | e358b3911703d172927fbfb5bb88e1e139757dc0dbe959fc6d95795593d8a97b |