Skip to main content

Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform, with Python 2.6, 2.6, 3.3+

Project description

Travis Coveralls Docs

xlwt

This is a library for developers to use to generate spreadsheet files compatible with Microsoft Excel versions 95 to 2003.

The package itself is pure Python with no dependencies on modules or packages outside the standard Python distribution.

Installation

Do the following in your virtualenv:

pip install xlwt

Quick start

import xlwt
from datetime import datetime

style0 = xlwt.easyxf('font: name Times New Roman, color-index red, bold on',
    num_format_str='#,##0.00')
style1 = xlwt.easyxf(num_format_str='D-MMM-YY')

wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')

ws.write(0, 0, 1234.56, style0)
ws.write(1, 0, datetime.now(), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))

wb.save('example.xls')

Documentation

Documentation can be found in the docs directory of the xlwt package. If these aren’t sufficient, please consult the code in the examples directory and the source code itself.

The latest documentation can also be found at: http://xlwt.readthedocs.org/en/latest/

Problems?

Try the following in this order:

Acknowledgements

xlwt is a fork of the pyExcelerator package, which was developed by Roman V. Kiseliov. This product includes software developed by Roman V. Kiseliov <roman@kiseliov.ru>.

xlwt uses ANTLR v 2.7.7 to generate its formula compiler.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

xlwt-1.0.0.tar.gz (129.6 kB view details)

Uploaded Source

Built Distribution

xlwt-1.0.0-py2.py3-none-any.whl (141.0 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file xlwt-1.0.0.tar.gz.

File metadata

  • Download URL: xlwt-1.0.0.tar.gz
  • Upload date:
  • Size: 129.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for xlwt-1.0.0.tar.gz
Algorithm Hash digest
SHA256 ac432939eec8daa9f88af994ff53f009e607a4e1102772ec0be0b2a86b2c1cf9
MD5 5e5e4eae8fe7ee3d43f9324767ad925e
BLAKE2b-256 db4617afa9309022530e5da9197293a62825c40dd51172addfa13784d0efb826

See more details on using hashes here.

File details

Details for the file xlwt-1.0.0-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for xlwt-1.0.0-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 584d00415f8a27c95a75c5036d37117579c9199ff6d4d4ed98fce43d1b7aa377
MD5 97be1043438ac373ffbc0811eec30521
BLAKE2b-256 95fcfdbb4a90f00c2d28864972d68a35df4075d394a7082b789c10b6e773d780

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page