Command-line interface for extracting data from Excel documents.
Project description
exex
CLI for extracting data from Excel documents
Installation
pip install exex-cli
Usage
Synopsis
exex 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 sample.xlsx --format json
Get cell range as CSV
python -m exex_cli sample.xlsx --range A1:A3 --format csv
Development
Setup
poetry install
Tests (local Python version)
poetry run pytest
Code formatting (black)
poetry run black .
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
exex-cli-1.0.1.tar.gz
(4.5 kB
view hashes)
