exex-cli
CLI for extracting data from Excel documents
Installation
pip install exex-cli
Usage
Synopsis
python -m exex_cli extract FILENAME --sheet SHEET --range RANGE --format FORMAT
| Parameter | Type | Default | Description |
|---|---|---|---|
FILENAME |
(required) string | Path to .xlsx file. | |
[SHEET] |
(optional) string or int | 0 (first sheet) |
Name or index of sheet |
[RANGE] |
(optional) range | all (all values) |
Range to get values from |
[FORMAT] |
(optional) string | text |
text, table, json, csv |
Type of ranges
| Type | Syntax | Example |
|---|---|---|
| All values | all |
all |
| Cell by name | [COLUMN_NAME][ROW_NUMBER] |
A1 |
| Cell by index | [COLUMN_INDEX],[ROW_INDEX] |
1,1 |
| Cell range | [FROM]:[TO] |
A1:A3 |
| Column | [COLUMN_NAME] |
A |
| Column range | [FROM]:[TO] |
A:C |
| Row | [ROW_NUMBER] |
1 |
| Row range | [FROM]:[TO] |
1:3 |
Examples
Get all values as JSON
python -m exex_cli extract sample.xlsx --format json
Get cell range as CSV
python -m exex_cli extract sample.xlsx --range A1:A3 --format csv
Development
Setup
poetry install
Tests (local Python version)
poetry run pytest
Code formatting (black)
poetry run black .
1 maintainer
Release files for exex-cli 1.0.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| exex-cli-1.0.3.tar.gz | 4.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| exex_cli-1.0.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 9.5 kB
Release files / exex-cli-1.0.3.tar.gz
| Download URL | exex-cli-1.0.3.tar.gz |
|---|---|
| Size | 4.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
de46949cffa5c8d63180bd37098da073afb45cadab552ad86cf06930ecf97e84
|
|
BLAKE2b-256 checksum How to use checksums |
252e3968c5c74ab773567db096ef33b58b328f3cb9f27eb8d54cba242794ccea
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.1.11 CPython/3.8.10 Linux/5.4.0-90-generic
|
Release files / exex_cli-1.0.3-py3-none-any.whl
| Download URL | exex_cli-1.0.3-py3-none-any.whl |
|---|---|
| Size | 5.1 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
f608649887ddc1e74ac24836083004a8d5c54400c108d574d1996b09919b73b6
|
|
BLAKE2b-256 checksum How to use checksums |
3fb3a6a4d9190d80df9a216eb8f7b4557fe1f0d4212d8abc961ca9b2c5588b09
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.1.11 CPython/3.8.10 Linux/5.4.0-90-generic
|
