Skip to main content

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

Project description

coverage status

Introduction

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

The 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")

Documentation

The documentation is at: https://openpyxl.readthedocs.io

  • installation methods

  • code examples

  • instructions for contributing

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

Project details


Release history Release notifications | RSS feed

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.5.9.tar.gz (1.9 MB view details)

Uploaded Source

File details

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

File metadata

  • Download URL: openpyxl-2.5.9.tar.gz
  • Upload date:
  • Size: 1.9 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.19.1 setuptools/40.4.3 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.5.6

File hashes

Hashes for openpyxl-2.5.9.tar.gz
Algorithm Hash digest
SHA256 022c0f3fa1e873cc0ba20651c54dd5e6276fc4ff150b4060723add4fc448645e
MD5 cb1f76fd964d46b776d61e1bdd00d2a0
BLAKE2b-256 041864737cc6c5233e15374d21b4958a5600be52359e71063b4d4e7a604a1387

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