xlwt

What it is and what it does

xlwt is a pure-Python library for writing Microsoft Excel spreadsheets in the XLS format (Excel 97–2003). It provides a straightforward API to create workbooks, add sheets, write cells with formatting, and save files—all without requiring external C libraries or system dependencies. The package includes styling support (fonts, colors, number formats) and formula generation.

The library has been in production/stable status since its initial release but has not been actively maintained since 2017. It is designed for legacy Excel compatibility and does not support the modern XLSX format. For projects targeting current Excel versions or requiring ongoing maintenance and updates, this package should be considered end-of-life.

Use it for:

• Generate legacy XLS reports from Python scripts in environments where Excel 97–2003 format is required or expected.
• Export tabular data to XLS files with basic cell styling (fonts, colors, number formatting) without external dependencies.
• Build batch spreadsheet generation tools for older enterprise systems that do not accept XLSX or other modern formats.
• Create simple financial or business reports with formulas and formatted cells in the XLS format.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Generates Microsoft Excel 97–2003 XLS spreadsheet files from Python code with no external dependencies.

No, unless you are maintaining legacy code that specifically requires XLS output and cannot be migrated. The package is abandoned and will not receive security updates or compatibility fixes. For new projects, use a maintained alternative that supports XLSX (the modern Excel standard). If you must generate XLS files, xlwt works but carries the risk of unpatched bugs and incompatibility with future Python versions.

Install

xlwt on PyPI

pip install xlwt

uv add xlwt

poetry add xlwt

Installing xlwt

Before you install

Installation is frictionless—a pure-Python wheel with no runtime dependencies. However, the package has been abandoned since 2017 and receives no maintenance; it will not be updated for modern Python versions or security issues.

License in practice

BSD license is permissive and poses no restrictions on commercial or private use, modification, or redistribution.

Quickstart

pip install xlwt

import xlwt
from datetime import datetime

wb = xlwt.Workbook()
ws = wb.add_sheet('Sheet1')
ws.write(0, 0, 'Hello')
ws.write(1, 0, datetime.now())
wb.save('output.xls')

Targets Excel 97–2003 format (.xls); modern Excel versions prefer .xlsx. Abandoned since 2017; compatibility with current Python versions is not guaranteed.

Verify before relying

• Current compatibility with Python 3.7+ (classifiers list up to 3.6; last release was 2017-08-22)
• Whether the package works reliably on modern operating systems and Python distributions
• Active alternatives or recommended successors for new projects

Package facts

Evidence: xlwt-1.3.0-py2.py3-none-any.whl

Keywords: xls, excel, spreadsheet, workbook, worksheet, pyExcelerator

Tags

More Python Modules packages