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 PyPI

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.1.2.tar.gz (153.4 kB view details)

Uploaded Source

Built Distribution

xlwt-1.1.2-py2.py3-none-any.whl (99.9 kB view details)

Uploaded Python 2 Python 3

File details

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

File metadata

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

File hashes

Hashes for xlwt-1.1.2.tar.gz
Algorithm Hash digest
SHA256 aed648c17731f40f84550dd2a1aaa53569f0cbcaf5610ba895cd2632587b723c
MD5 fadf8d1be8c5f071561c4145ed5f5b89
BLAKE2b-256 0b69644313df86e6375ec2c6b34ec8ac544b9cc7803b7d943223d32811860f3d

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for xlwt-1.1.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 61e2a8bcfd0f62fa27a26964bed3b4d1c4218c8ff155d7edbeb2c15f8a57c247
MD5 63dc2ad31b86e6f18e72910f85aa3b01
BLAKE2b-256 0590e9a256ae4689a8daf73635e7761a8f9ece0a78fcf9af87bb9ef017e5bd85

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