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.1.tar.gz
(108.5 kB
view details)
File details
Details for the file openpyxl-2.2.1.tar.gz.
File metadata
- Download URL: openpyxl-2.2.1.tar.gz
- Upload date:
- Size: 108.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a23f52cbc8b8344fe3324739de30c75ab40d9c3c16170b45351aa17739af2042
|
|
| MD5 |
6afea6c209aca8eef773b61f23f4b92d
|
|
| BLAKE2b-256 |
4dae97826ed4870dc330ea2e011cb2754824ec37fcd878c61c6975e991ece545
|