pip install exex-clipython -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 |
Get all values as JSON
python -m exex_cli extract sample.xlsx --format jsonGet cell range as CSV
python -m exex_cli extract sample.xlsx --range A1:A3 --format csvSetup
poetry installTests (local Python version)
poetry run pytestCode formatting (black)
poetry run black .