Skip to main content

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 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

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

openpyxl-2.2.2.tar.gz (108.5 kB view details)

Uploaded Source

File details

Details for the file openpyxl-2.2.2.tar.gz.

File metadata

  • Download URL: openpyxl-2.2.2.tar.gz
  • Upload date:
  • Size: 108.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for openpyxl-2.2.2.tar.gz
Algorithm Hash digest
SHA256 2eec264a2eb42a9353319f0f939cfeacf75cf88b803fbf02d0dd5cc53f13b705
MD5 94668360e4a9726b4d0a3c5884df802e
BLAKE2b-256 ef1c2e708d00551777b6e4543a6bee74a170ca0f9517a319b0c458bbb3b535cb

See more details on using hashes here.

Release history Release notifications | RSS feed

3.2.0b1

2 files

3.1.5

2 files

3.1.4

2 files

3.1.3

2 files

3.1.2

2 files

3.1.1

2 files

3.1.0

2 files

3.0.10

2 files

3.0.9

2 files

3.0.7

2 files

3.0.6

2 files

3.0.5

2 files

3.0.4

2 files

3.0.3

1 file

3.0.2

1 file

3.0.1

1 file

3.0.0

1 file

2.6.4

1 file

2.6.3

1 file

2.6.2

1 file

2.6.1

1 file

2.6.0

1 file

2.5.14

1 file

2.5.12

1 file

2.5.11

1 file

2.5.10

1 file

2.5.9

1 file

2.5.8

1 file

2.5.7

1 file

2.5.6

1 file

2.5.5

1 file

2.5.4

1 file

2.5.3

1 file

2.5.2

1 file

2.5.1

1 file

2.5.0

1 file

2.4.11

1 file

2.4.10

1 file

2.4.9

1 file

2.4.8

1 file

2.4.7

1 file

2.4.5

1 file

2.4.4

1 file

2.4.3

2.4.2

1 file

2.4.1

1 file

2.4.0

1 file

2.3.5

1 file

2.3.4

1 file

2.3.3

1 file

2.3.2

1 file

2.3.1

1 file

2.3.0

1 file

2.2.6

1 file

2.2.5

1 file

2.2.4

1 file

2.2.3

1 file

This release

2.2.2 This release

1 file

2.2.1

1 file

2.2.0

1 file

2.1.5

1 file

2.1.4

1 file

2.1.3

1 file

2.1.2

1 file

2.1.1

1 file

2.1.0

1 file

2.0.5

1 file

2.0.4

1 file

2.0.3

1 file

2.0.2

2 files

1.8.6

2 files

1.8.5

2 files

1.8.4

2 files

1.8.3

2 files

1.8.2

2 files

1.8.1

2 files

1.8.0

2 files

1.7.0

2 files

1.6.2

1 file

1.6.1

1 file

1.5.8

1 file

1.5.7

1 file

1.5.6

1 file

1.5.5

1 file

1.5.4

1 file

1.5.3

1 file

1.5.2

1 file

1.5.1

1 file

1.5.0

1 file

1.2.3

1 file

1.1.7

1 file

1.1.6

1 file

1.1.5

1 file

1.1.0

3 files

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page