loongson/pypi/: openpyxl-3.0.10 metadata and description

Homepage Simple index

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

author See AUTHORS
author_email charlie.clark@clark-consulting.eu
classifiers
  • Development Status :: 5 - Production/Stable
  • Operating System :: MacOS :: MacOS X
  • Operating System :: Microsoft :: Windows
  • Operating System :: POSIX
  • License :: OSI Approved :: MIT License
  • Programming Language :: Python
  • Programming Language :: Python :: 3.6
  • Programming Language :: Python :: 3.7
  • Programming Language :: Python :: 3.8
  • Programming Language :: Python :: 3.9
license MIT
platform
  • UNKNOWN
project_urls
  • Documentation, https://openpyxl.readthedocs.io/en/stable/
  • Source, https://foss.heptapod.net/openpyxl/openpyxl
  • Tracker, https://foss.heptapod.net/openpyxl/openpyxl/-/issues
requires_dist
  • et-xmlfile
requires_python >=3.6

Because this project isn't in the mirror_whitelist, no releases from root/pypi are included.

File Tox results History
openpyxl-3.0.10-py2.py3-none-any.whl
Size
236 KB
Type
Python Wheel
Python
2.7
  • Replaced 2 time(s)
  • Uploaded to loongson/pypi by loongson 2023-06-01 00:42:54
openpyxl-3.0.10.tar.gz
Size
176 KB
Type
Source
  • Replaced 2 time(s)
  • Uploaded to loongson/pypi by loongson 2023-06-01 00:42:55
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.

Security

By default openpyxl 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 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