Source

openpyxl /

Filename Size Date modified Message
doc
openpyxl
195 B
Remove from and import from coverage exclusion.
123 B
flow initialization: Added configuration file.
160 B
Harmonise EOL for ReST files.
240 B
Improve illegal XML character detection.
2.5 KB
Prune duplicate tags.
161 B
Install inlines all instructions.
1.2 KB
Update docs.
1.7 KB
Harmonise EOL for ReST files.
133 B
Keep tests out of the distribution.
1.0 KB
version
694 B
Update TODO
283 B
prevent tox from testing itself
47 B
[dev] adding developer requirements file for pip
22 B
[wheels] added setup file for wheel package generation
2.6 KB
fix classifiers
399 B
Get shippable to update dependencies
2.8 KB
Adjust API documentation to reflect new structure.

openpyxl

openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm files.

It was born from lack of existing library to read/write natively from Python the Office Open XML format.

All kudos to the PHPExcel team as openpyxl is based on PHPExcel http://www.phpexcel.net/

Mailing List

Official user list can be found on http://groups.google.com/group/openpyxl-users

Sample code:

from openpyxl import Workbook
wb = Workbook()

# grab the active worksheet
ws = wb.active

# Data can be directly to cells
ws['A1'] = 42

# Rows can also be appended
ws.append([1, 2, 3])

# Python types will automatically be converted
import datetime
ws['A2'] = datetime.datetime.now()

# Save the file
wb.save("sample.xlsx")

Official documentation

The documentation is at: http://openpyxl.readthedocs.org

  • installation methods
  • code examples
  • instructions for contributing

Release notes: http://openpyxl.readthedocs.org/en/latest/changes.html