Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform.
Python GAP
Tag: 0.7.0

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
tests
xlwt
HISTORY.html
MANIFEST
PKG-INFO
README.html
licences.py
setup.py

README.html

<p><h3>Python package "xlwt"</h3>
</p>
<p><b>Purpose:</b> Provide a library for developers to use to generate
    spreadsheet files compatible with Microsoft Excel versions 95 to 2003.
</p>
<p><b>Maintainer:</b> John Machin, Lingfo Pty Ltd (sjmachin@lexicon.net)
</p>
<p><b>Licence:</b> BSD-style (see licences.py)
</p>
<p><b>Version of xlwt:</b> 0.7.0
</p>
<p><b>Version of Python required:</b> 2.3 or later.
</p>
<p><b>External modules required:</b> None
</p>
<p>
The package itself is pure Python with no dependencies on modules or packages
outside the standard Python distribution.
</p>
<p><b>Quick start:</b>
</p>
<pre><code>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')
</code></pre><p>
</p>
<p><b>Installation:</b>
</p>
<ul>
<li> Any OS: Unzip the .zip file into a suitable directory,
    chdir to that directory, then do "python setup.py install".
</li>
<li> If PYDIR is your Python installation directory:
    the main files are in PYDIR/Lib/site-packages/xlwt,
    docs are in the doc subdirectory.
</li>
<li> If os.sep != "/": make the appropriate adjustments.
</li>
</ul>
<p><b>Download URLs:</b>
</p>
<ul><li>Packaged: http://pypi.python.org/pypi/xlwt
</li>
<li>SVN: https://secure.simplistix.co.uk/svn/xlwt/trunk
</li>
</ul>
<p><b>Documentation:</b>
</p>
<p>
Documentation can be found in the 'doc' directory of the xlwt package.
If these aren't sufficient, please consult the code in the
examples directory and the source code itself.
</p>
<p><b>Problems:</b>
</p>
<p>Try the following in this order:</p>
<ol>
<li>Read the source</li>
<li>Ask a question on http://groups.google.com/group/python-excel/</li>
<li>E-mail the xlwt maintainer (sjmachin at lexicon.net), including
    "[xlwt]" as part of the message subject.</li>
</ol>
<p><b>Acknowledgements:</b>
</p>
<ul><li> xlwt is a fork of the pyExcelerator package, which was developed by
Roman V. Kiseliov.
"This product includes software developed by Roman V. Kiseliov &lt;roman@kiseliov.ru&gt;."
</li>
<li> &lt;&lt; a growing list of names; see HISTORY.html &gt;&gt;: feedback, testing, test files, ...
</li></ul>
Something went wrong with that request. Please try again.