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)
| File | Size | Uploaded | |
|---|---|---|---|
| editpyxl-0.1.10.tar.gz | 11.0 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| 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
|