Excel file manipulation toolset.
Project description
xlsxhelper
Excel file manipulation toolset.
Notice
The library is based on library openpyxl, so only xlsx (new excel format) files are supported.
Help Functions
- get_workbook
- get_worksheet
- get_merged_range_string
- parse_cols
- parse_rows
- get_cells
- set_cells_data
- load_data_from_workbook
- get_merged_ranges
- copy_cells
- merge_ranges
Test Passed With Pythons
- 2.7
- 3.4
- 3.5
- 3.6
- 3.7
- 3.8
- 3.9
- 3.10
- 3.11
Releases
v0.3.2 2023/09/10
- Fix unit test problem.
v0.3.1 2022/01/10
- Fix license file missing problem.
- Add set_cells_data function.
v0.3.0 2020/07/19
- Add workbook and worksheet create support.
v0.2.1 2019/08/31
- Fix load_data_from_workbook get raw function statement problem.
- Fix worksheet.merged_cell_ranges deprecating problem, use worksheet.merged_cells.ranges instead.
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
xlsxhelper-0.3.2.tar.gz
(5.4 kB
view details)
Built Distribution
File details
Details for the file xlsxhelper-0.3.2.tar.gz.
File metadata
- Download URL: xlsxhelper-0.3.2.tar.gz
- Upload date:
- Size: 5.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.11.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 3fca91ede0388011ee5e2ac1217e62823cf2291a0e9adda00ba2dd29b3970b64 |
|
| MD5 | d0de2e43b364208e20acfc4e0e688787 |
|
| BLAKE2b-256 | 3464c447543b75276277d3ea6cb42131989346c07f89219ebf9f799f63641031 |
File details
Details for the file xlsxhelper-0.3.2-py3-none-any.whl.
File metadata
- Download URL: xlsxhelper-0.3.2-py3-none-any.whl
- Upload date:
- Size: 5.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.11.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 6b5aab9080143e910d2b0fc1a1ab36e3fdd714a0fdb9571bbbc8be330817eebf |
|
| MD5 | 050774bb308306ee37ad8ff0d711907b |
|
| BLAKE2b-256 | 007a66d607e4df80244f2907bb8fe75eb97eddacb3ab4485bf249489dbd70cc3 |
