Skip to main content

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.10

  • Updated MutableSet import for python 3.10 compatibility

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.

Metadata

Release files for editpyxl 0.1.10

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for editpyxl 0.1.10
File Size Uploaded
editpyxl-0.1.10.tar.gz 11.0 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for editpyxl 0.1.10
File Interpreter ABI Platform
editpyxl-0.1.10-py2.py3-none-any.whl Python 3, Python 2 none any Details

Total release size: 28.1 kB

Release files / editpyxl-0.1.10.tar.gz

Download URL editpyxl-0.1.10.tar.gz
Size 11.0 kB
Tags Source
SHA-256 checksum
How to use checksums
d1da99a18a9930bc01e8e9b73429a989eae6966ac9ef555e3721a0fad07e65c6
BLAKE2b-256 checksum
How to use checksums
8919c272aaecb3477b20ab73264af7e59cacc7dca5dea531d5ed5aa8a2672194
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.6.0 importlib_metadata/4.8.2 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.10.0

Release files / editpyxl-0.1.10-py2.py3-none-any.whl

Download URL editpyxl-0.1.10-py2.py3-none-any.whl
Size 17.1 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
06ac814fbb68e2ae58484998cc394b6717b9cdcc8f43b25d99c9b1897038692b
BLAKE2b-256 checksum
How to use checksums
0e6c967fe571df77812d11cd630591aa24377f74df862388123b2958b0503524
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.6.0 importlib_metadata/4.8.2 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.10.0

Release history Release notifications | RSS feed

This release

0.1.10 This release

2 release files

0.1.9

2 release files

0.1.8

4 release files

0.1.7

2 release files

0.1.6

2 release files

0.1.4

1 release file

0.1.3

2 release files

0.1.2

1 release file

0.1.1

1 release file

0.1.0

1 release file

0.0.9

2 release files

0.0.8

2 release files

0.0.7

2 release files

0.0.6

2 release files

0.0.5

2 release files

0.0.4

2 release files

0.0.3

1 release file

0.0.2

2 release files

0.0.1

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page