Skip to main content

Command-line interface for extracting data from Excel documents.

Project description

exex-cli Build Status Code style: black

Command-line interface 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

python -m exex_cli sample.xlsx 

Get all values as JSON

python -m exex_cli sample.xlsx --format json 

Development

Tests (local Python version)

poetry run pytest

Tests (all Python versions defined in tox.ini)

poetry run tox

Code formatting (black)

poetry run black .

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for exex-cli, version 0.1.2
Filename, size File type Python version Upload date Hashes
Filename, size exex_cli-0.1.2-py3-none-any.whl (5.0 kB) File type Wheel Python version py3 Upload date Hashes View hashes
Filename, size exex-cli-0.1.2.tar.gz (4.4 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page