Skip to main content

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

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.1.3.tar.gz (96.2 kB view details)

Uploaded Source

File details

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

File metadata

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

File hashes

Hashes for openpyxl-2.1.3.tar.gz
Algorithm Hash digest
SHA256 b7647d0c0f7f2c4a6cc63fd6759f02fe918542b03f027b51da40994df9d43a37
MD5 f75c7b32710e863253d4757c914d9de0
BLAKE2b-256 867abba821c554b5fbde20aaa70cf5ae8c284883f38162deee7852e068db6246

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

2.2.2

1 file

2.2.1

1 file

2.2.0

1 file

2.1.5

1 file

2.1.4

1 file

This release

2.1.3 This release

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

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page