1. openpyxl
  2. openpyxl
  3. openpyxl

Source

openpyxl /

Filename Size Date modified Message
doc
openpyxl
227 B
Exclude unused module from coverage. No idea if we'll ever use this auto-generated code.
123 B
flow initialization: Added configuration file.
160 B
Harmonise EOL for ReST files.
266 B
Update ignore.
0 B
Move etree.xmlfile implementation to separate package and remove subrepository.
0 B
Move etree.xmlfile implementation to separate package and remove subrepository.
4.0 KB
Prep 2.4.8 release
1.4 KB
New contributor in AUTHORS.rst
1.7 KB
Harmonise EOL for ReST files.
206 B
Exclude scatchpad from being packaged.
1.1 KB
Update Readme.
206 B
Merge
499 B
Disable pytest-warnings which cause random test failures.
57 B
Make sure pytest-cov is in the requirements.
22 B
[wheels] added setup file for wheel package generation
2.3 KB
486 B
Update shippable config.
3.3 KB
Set parameter about skipping interpreters

openpyxl

openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm 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 was initially based on PHPExcel

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 assigned 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: https://openpyxl.readthedocs.io

  • installation methods
  • code examples
  • instructions for contributing

Release notes: https://openpyxl.readthedocs.io/en/latest/changes.html