Skip to main content

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

Project description

coverage status

Introduction

openpyexcel is a fork of openpyxl that has some additional improvements, most notably the ability to write formula values.

openpyexcel 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 openpyexcel was initially based on PHPExcel.

Security

By default openpyexcel does not guard against quadratic blowup or billion laughs xml attacks. To guard against these attacks install defusedxml.

Mailing List

The user list can be found on http://groups.google.com/group/openpyxl-users

Sample code:

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


Download files

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

Source Distribution

openpyexcel-2.5.14.tar.gz (173.9 kB view details)

Uploaded Source

Built Distribution

openpyexcel-2.5.14-py2.py3-none-any.whl (245.0 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file openpyexcel-2.5.14.tar.gz.

File metadata

  • Download URL: openpyexcel-2.5.14.tar.gz
  • Upload date:
  • Size: 173.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.21.0 setuptools/40.6.3 requests-toolbelt/0.9.1 tqdm/4.28.1 CPython/3.7.1

File hashes

Hashes for openpyexcel-2.5.14.tar.gz
Algorithm Hash digest
SHA256 056f7f9cf543218b6e1a7ce2c3399b8c48f377c82c5d5ca23d7c679a660d9a01
MD5 97c91411f239a38be14b88e42609d0d6
BLAKE2b-256 86060f33d52818546b9dafd8be69f3dda44ee4ecf5ce4d3ddba63d862a3599d6

See more details on using hashes here.

File details

Details for the file openpyexcel-2.5.14-py2.py3-none-any.whl.

File metadata

  • Download URL: openpyexcel-2.5.14-py2.py3-none-any.whl
  • Upload date:
  • Size: 245.0 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.21.0 setuptools/40.6.3 requests-toolbelt/0.9.1 tqdm/4.28.1 CPython/3.7.1

File hashes

Hashes for openpyexcel-2.5.14-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 f18f4efadbc25a26870885f342e14b6cd6862ca1f4b8195b394fc2681ccdbaab
MD5 788fbfbca2059f3d955224d22f275ded
BLAKE2b-256 32e1722047fae7a46b658d7fa038cf5b952fbbb150c3c8a31012e4fb76eba27d

See more details on using hashes here.

Supported by

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