Skip to main content

A Python library to read/write Excel 2007 xlsx/xlsm files

Project description

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

Project details


Release history Release notifications | RSS feed

This version

2.1.3

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.

Supported by

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