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
1 maintainer
Metadata
1 maintainer
Release files for excelkit 1.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| excelkit-1.0.0.tar.gz | 9.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| excelkit-1.0.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 22.3 kB
Release files / excelkit-1.0.0.tar.gz
| Download URL | excelkit-1.0.0.tar.gz |
|---|---|
| Size | 9.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
42f9e8b9e6efdafc4bedab206848ca2c78e1322bbba679d434e1b5b657338efb
|
|
BLAKE2b-256 checksum How to use checksums |
54015aa3893e8880ad65bf3c04a96aba6e20097a97bd5ce622a4286b708224d2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is 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
|
Release files / excelkit-1.0.0-py3-none-any.whl
| Download URL | excelkit-1.0.0-py3-none-any.whl |
|---|---|
| Size | 12.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
f562fcc990d4dbf62f8f4863b8b374558a0db521def3502ae101dd57e6a9399a
|
|
BLAKE2b-256 checksum How to use checksums |
8ae329e4c5a5cffac2ad423c3b60f4b341739901c4d73714de0542ab3d73c135
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is 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
|
