Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

A Python library to edit Excel 2007 xlsx/xlsm files

Project description

editpyxl

editpyxl is a Python library to non-destructively edit Excel 2010 xlsx/xlsm files.

The purpose is to edit excel files without otherwise modifying the excel document, to allow for efficient and quick edits of an excel file.

Many thanks to openpyxl for their hard work in developing a tool to read and writing excel files. https://bitbucket.org/ericgazoni/openpyxl

Official documentation

The homepage is http://editpyxl.readthedocs.org You will find:

  • every installation methods
  • the official documentation
  • code examples
  • instructions for contributing

0.1.9

  • Force closing of zip file before removing folder, to prevent PermissionError: [WinError 32] error.

0.1.8

  • Added worksheet function clear_formula_values. This deletes preset values in formulas to force recalculation, to solve issue in Excel 2016 not respecting force recalc flags or the absence of the calcChain.xml

0.1.5

  • Updated lxml writing for python3

0.1.4

  • Updated uuid1().get_hex() -> uuid1().hex

0.1.3

  • Added wb[‘sheetname’] notation.
  • Added wb.sheetnames

0.1.2

  • Added ws[‘A1’] notation.

0.1.1

  • Added ws.dump() to dump all cell values.

0.1.0

  • Added wb.hide_sheet() / wb.unhide_sheet()

0.0.9 (unreleased)

  • Fixed filename parsing.

0.0.8 (unreleased)

  • Added function for updating formulas.

0.0.7 (unreleased)

  • Remove formulas from cells when setting value and remove calcChain.xml.

0.0.1 (unreleased)

Initial Release

  • Initial project released in Alpha.

Project details


Download files

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

Files for editpyxl, version 0.1.9
Filename, size File type Python version Upload date Hashes
Filename, size editpyxl-0.1.9-py2.py3-none-any.whl (17.0 kB) File type Wheel Python version py2.py3 Upload date Hashes View hashes
Filename, size editpyxl-0.1.9.tar.gz (9.4 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page