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 .