A ToolKit to Operate Excel File
Project description
A ToolKit to Operate Excel File
Installation
pip install excelkit
Tools
parse - parse excel file
excelkit parse --help
# or
excel-parse --help
excel-parse demo.xlsx
excel-parse demo.xlsx -o out.tsv
excel-parse demo.xlsx -O table
excel-parse demo.xlsx -O table --color red
excel-parse demo.xlsx -O json --indent 2
excel-parse demo.xlsx -O json --indent 2 --header
excel-parse demo.xlsx --pager
build - build excel file
excelkit build --help
# or
excel-build --help
excel-build demo/genelist demo/hsa00010.conf
excel-build demo/genelist demo/hsa00010.conf -o kegg.xlsx
excel-build demo/genelist demo/hsa00010.conf -o kegg.xlsx -s GENE,KEGG
excel-build demo/genelist demo/hsa00010.conf -h
excel-build demo/genelist demo/hsa00010.conf -hs
excel-build demo/genelist demo/hsa00010.conf -hs -bs
cat demo/genelist | excel-build
concat - concat excel files
excelkit concat --help
# or
excel-concat --help
examples:
excel-concat input1.xlsx input2.xlsx -o out.xlsx
excel-concat input1.xlsx input2.xlsx -o out.xlsx --keep-fmt
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
excelkit-1.0.0.tar.gz
(9.6 kB
view details)
Built Distribution
excelkit-1.0.0-py3-none-any.whl
(12.7 kB
view details)
File details
Details for the file excelkit-1.0.0.tar.gz.
File metadata
- Download URL: excelkit-1.0.0.tar.gz
- Upload date:
- Size: 9.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.25.0 setuptools/50.3.2 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.6.8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 42f9e8b9e6efdafc4bedab206848ca2c78e1322bbba679d434e1b5b657338efb |
|
| MD5 | 2358d1ab7cb97bc1920f09fae6783bd9 |
|
| BLAKE2b-256 | 54015aa3893e8880ad65bf3c04a96aba6e20097a97bd5ce622a4286b708224d2 |
File details
Details for the file excelkit-1.0.0-py3-none-any.whl.
File metadata
- Download URL: excelkit-1.0.0-py3-none-any.whl
- Upload date:
- Size: 12.7 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.25.0 setuptools/50.3.2 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.6.8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | f562fcc990d4dbf62f8f4863b8b374558a0db521def3502ae101dd57e6a9399a |
|
| MD5 | db7db37ce015b7244f3eb1a040c5e771 |
|
| BLAKE2b-256 | 8ae329e4c5a5cffac2ad423c3b60f4b341739901c4d73714de0542ab3d73c135 |
