xlsxopera
Working on xlsx (Microsoft Excel) files. Convert to list, dict, get headers, cell values, positions and more.
Developed by voidayan (c) 2022
Install
Install package from pip:
pip3 install xlsxopera
Note: Required packages is openpyxl
How to work
Create an object
from xlsxopera import Notebook
# Load file to operate and sheet name
notebook = Notebook("file-to-path.xlsx", "sheet_name")
# Or load file to operate without sheet name. Default will be active spreadsheet.
notebook = Notebook("file-to-path.xlsx")
Get rows in list of lists:
# Get all rows (from 1 to last)
rows_in_spreadsheet = notebook.list_rows()
# Get rows (for e.g, from 9 to 13)
rows_in_spreadsheet = notebook.list_rows(start=9, end=13)
1 maintainer
Metadata
1 maintainer
Release files for xlsxopera 1.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| xlsxopera-1.1.tar.gz | 5.3 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| xlsxopera-1.1-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 11.0 kB
Release files / xlsxopera-1.1.tar.gz
| Download URL | xlsxopera-1.1.tar.gz |
|---|---|
| Size | 5.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
1aa06a032fe28a675be5e0fed7ef3a055715143ee23d78c05934a1f493ee92b8
|
|
BLAKE2b-256 checksum How to use checksums |
592a4e6daf91f81f28e62aab086914f0afb6b365eb727d8440c9ec661a6870a9
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.6
|
Release files / xlsxopera-1.1-py3-none-any.whl
| Download URL | xlsxopera-1.1-py3-none-any.whl |
|---|---|
| Size | 5.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
a8f7013778a1546d38e12af725ec7fe81b937a75b1d7bc6510c948ae15a4dd34
|
|
BLAKE2b-256 checksum How to use checksums |
0487169579036df6040bcdbf444482eb937ce858a8c625f5871a5970561fe938
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.6
|
