easy excel tool
在实际工作中，沉淀的一些简易、好用的excel数据处理工具，减少重复代码与文件冗余，希望一样能为使用者带来益处。如果您也想贡献好的代码片段，请将代码以及描述，通过邮箱（ xinkonghan@gmail.com ）发送给我。代码格式是遵循自我主观，如存在不足敬请指出！
安装
pip install easy-excel-tool
主要功能
excelcreate_excel创建一个空白的excel文件（可指定sheet名）add_sheet对指定excel文件新增sheet页（可指定sheet名）get_sheet_name获取excel文件所有sheet名remove_sheet删除excel文件中指定sheet页write_excel对excel文件写入或追加数据（可指定填充列，保留头部）
简单使用
from easy_excel_tool import Excel
excel = Excel('./test.xlsx')
# excel.create_excel(inplace=True)
# excel.add_sheet(sheet_name=[
# 'donation_information',
# ])
data = [
{'a': 1, 'b': 5, 'c': '88'},
{'a': 7, 'b': 9, 'c': 66},
]
excel.write_excel(
data,
mode='w+',
sheet_name='Sheet1',
fill_column={'fill_column': 'fill'},
header=True,
inplace=False,
)
链接
Github：https://github.com/hanxinkong/easy-excel-tool
在线文档：https://easy-excel-tool.xink.top/
注明
1 maintainer
Metadata
1 maintainer
Release files for easy-excel-tool 1.0.5
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| easy_excel_tool-1.0.5.tar.gz | 5.1 kB | Without provenance | Details for easy_excel_tool-1.0.5.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| easy_excel_tool-1.0.5-py3-none-any.whl | Python 3 | none | any | Details for easy_excel_tool-1.0.5-py3-none-any.whl |
Total release size: 10.5 kB
Release files / easy_excel_tool-1.0.5.tar.gz
| Download URL | easy_excel_tool-1.0.5.tar.gz |
|---|---|
| Size | 5.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e26c2bfbb8aab08a4c93b09c9b3f1ee252c71e717908e4e793e61d073034eb6f
|
|
BLAKE2b-256 checksum How to use checksums |
3252c6b410db27eecd53d6440b063bd71943f75ba0b257e90e11138280e3f97c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.7.6
|
Release files / easy_excel_tool-1.0.5-py3-none-any.whl
| Download URL | easy_excel_tool-1.0.5-py3-none-any.whl |
|---|---|
| Size | 5.5 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
760a9dfd77c93b5b10e8886abd6edaa869c2ee40e2e53b5579743cf84f4745ae
|
|
BLAKE2b-256 checksum How to use checksums |
48636996c058c009c60318d4e8ed48d474c6fff92d7ddea6a82bad8c35fdabd2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.7.6
|
Security for easy-excel-tool 1.0.5
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
