用于从Excel文档中提取数据的命令行界面。
exex-cli的Python项目详细描述
exex命令行![Build Status](https://warehouse-camo.ingress.cmh1.psfhosted.org/b2f2d2a569431081ae213f60ae84eac49b4243e9/68747470733a2f2f7472617669732d63692e6f72672f76696b70652f657865782d636c692e7376673f6272616e63683d6d6173746572)
![Code style: black](https://warehouse-camo.ingress.cmh1.psfhosted.org/fbfdc7754183ecf079bc71ddeabaf88f6cbc5c00/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f636f64652532307374796c652d626c61636b2d3030303030302e737667)
Command-line interface for extracting data from Excel documents.
安装
pip install exex-cli
使用
简介
^{pr2}$Parameter | Type | Default | Description |
---|---|---|---|
^{ | (required) string | Path to .xlsx file. | |
^{ | (optional) string or int | ^{ | Name or index of sheet |
^{ | (optional) range | ^{ | Range to get values from |
^{ | (optional) string | ^{ | ^{ |
范围类型
^{tb2}$示例
获取所有值
python -m exex_cli sample.xlsx
Get all values as JSON
python -m exex_cli sample.xlsx --format json
发展
Tests(本地Python版本)
poetry run pytest
Tests(在tox.ini
中定义的所有Python版本)
poetry run tox
Code格式化(黑色)
poetry run black .
- 项目
标签: