# easy excel tool
在实际工作中，沉淀的一些简易、好用的excel数据处理工具，减少重复代码与文件冗余，希望一样能为使用者带来益处。如果您也想贡献好的代码片段，请将代码以及描述，通过邮箱（ [xinkonghan@gmail.com](mailto:hanxinkong<xinkonghan@gmail.com>)
）发送给我。代码格式是遵循自我主观，如存在不足敬请指出！
## 安装
```shell
pip install easy-excel-tool
```
## 主要功能
- `excel`
- `create_excel` 创建一个空白的excel文件（可指定sheet名）
- `add_sheet` 对指定excel文件新增sheet页（可指定sheet名）
- `get_sheet_name` 获取excel文件所有sheet名
- `remove_sheet` 删除excel文件中指定sheet页
- `write_excel` 对excel文件写入或追加数据（可指定填充列，保留头部）
## 简单使用
```python
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/
## 注明
Raw data
{
"_id": null,
"home_page": "https://easy-excel-tool.xink.top/",
"name": "easy-excel-tool",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.6.8",
"maintainer_email": "",
"keywords": "easy,excel,tool",
"author": "hanxinkong",
"author_email": "xinkonghan@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/4d/34/f1e791cfe7c0a5f448dc5f72626e9b96b8ebaff210cda4e40821269a61b8/easy_excel_tool-1.0.4.tar.gz",
"platform": null,
"description": "# easy excel tool\r\n\r\n\u5728\u5b9e\u9645\u5de5\u4f5c\u4e2d\uff0c\u6c89\u6dc0\u7684\u4e00\u4e9b\u7b80\u6613\u3001\u597d\u7528\u7684excel\u6570\u636e\u5904\u7406\u5de5\u5177\uff0c\u51cf\u5c11\u91cd\u590d\u4ee3\u7801\u4e0e\u6587\u4ef6\u5197\u4f59\uff0c\u5e0c\u671b\u4e00\u6837\u80fd\u4e3a\u4f7f\u7528\u8005\u5e26\u6765\u76ca\u5904\u3002\u5982\u679c\u60a8\u4e5f\u60f3\u8d21\u732e\u597d\u7684\u4ee3\u7801\u7247\u6bb5\uff0c\u8bf7\u5c06\u4ee3\u7801\u4ee5\u53ca\u63cf\u8ff0\uff0c\u901a\u8fc7\u90ae\u7bb1\uff08 [xinkonghan@gmail.com](mailto:hanxinkong<xinkonghan@gmail.com>)\r\n\uff09\u53d1\u9001\u7ed9\u6211\u3002\u4ee3\u7801\u683c\u5f0f\u662f\u9075\u5faa\u81ea\u6211\u4e3b\u89c2\uff0c\u5982\u5b58\u5728\u4e0d\u8db3\u656c\u8bf7\u6307\u51fa\uff01\r\n\r\n## \u5b89\u88c5\r\n\r\n```shell\r\npip install easy-excel-tool\r\n```\r\n\r\n## \u4e3b\u8981\u529f\u80fd\r\n\r\n- `excel`\r\n - `create_excel` \u521b\u5efa\u4e00\u4e2a\u7a7a\u767d\u7684excel\u6587\u4ef6\uff08\u53ef\u6307\u5b9asheet\u540d\uff09\r\n - `add_sheet` \u5bf9\u6307\u5b9aexcel\u6587\u4ef6\u65b0\u589esheet\u9875\uff08\u53ef\u6307\u5b9asheet\u540d\uff09\r\n - `get_sheet_name` \u83b7\u53d6excel\u6587\u4ef6\u6240\u6709sheet\u540d\r\n - `remove_sheet` \u5220\u9664excel\u6587\u4ef6\u4e2d\u6307\u5b9asheet\u9875\r\n - `write_excel` \u5bf9excel\u6587\u4ef6\u5199\u5165\u6216\u8ffd\u52a0\u6570\u636e\uff08\u53ef\u6307\u5b9a\u586b\u5145\u5217\uff0c\u4fdd\u7559\u5934\u90e8\uff09\r\n\r\n## \u7b80\u5355\u4f7f\u7528\r\n\r\n```python\r\nfrom easy_excel_tool import Excel\r\n\r\nexcel = Excel('./test.xlsx')\r\n# excel.create_excel(inplace=True)\r\n# excel.add_sheet(sheet_name=[\r\n# 'donation_information',\r\n# ])\r\ndata = [\r\n {'a': 1, 'b': 5, 'c': '88'},\r\n {'a': 7, 'b': 9, 'c': 66},\r\n]\r\nexcel.write_excel(\r\n data,\r\n mode='w+',\r\n sheet_name='Sheet1',\r\n fill_column={'fill_column': 'fill'},\r\n header=True,\r\n inplace=False,\r\n)\r\n```\r\n\r\n## \u94fe\u63a5\r\n\r\nGithub\uff1ahttps://github.com/hanxinkong/easy-excel-tool\r\n\r\n\u5728\u7ebf\u6587\u6863\uff1ahttps://easy-excel-tool.xink.top/\r\n\r\n## \u6ce8\u660e\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "\u7b80\u6613\u3001\u597d\u7528\u7684excel\u64cd\u4f5c\u5de5\u5177\uff0c\u517c\u5177\u589e\u5220\u6539\u67e5\uff0c\u8868\u5408\u5e76\uff0c\u5bfc\u51fa\u7b49\u529f\u80fd",
"version": "1.0.4",
"project_urls": {
"Homepage": "https://easy-excel-tool.xink.top/"
},
"split_keywords": [
"easy",
"excel",
"tool"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5ef294c83d6637a1ce4d5b6c439acfe08f395a4b7788d51aea23acb9ae8c9f97",
"md5": "bff35dad6cfd9db16af005b036384a6c",
"sha256": "3e05e7c9ce2b50a9ed6d4b7dce084bc16aeab8f7290f96840492c368e1e1538f"
},
"downloads": -1,
"filename": "easy_excel_tool-1.0.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "bff35dad6cfd9db16af005b036384a6c",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6.8",
"size": 5452,
"upload_time": "2023-09-06T11:04:49",
"upload_time_iso_8601": "2023-09-06T11:04:49.263576Z",
"url": "https://files.pythonhosted.org/packages/5e/f2/94c83d6637a1ce4d5b6c439acfe08f395a4b7788d51aea23acb9ae8c9f97/easy_excel_tool-1.0.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "4d34f1e791cfe7c0a5f448dc5f72626e9b96b8ebaff210cda4e40821269a61b8",
"md5": "fb2b417c2c7fb6f6f4de295511540690",
"sha256": "24da658cce9acd2cd4d275125e97534a8fd27cd9989b0f284ddc08157f28a96f"
},
"downloads": -1,
"filename": "easy_excel_tool-1.0.4.tar.gz",
"has_sig": false,
"md5_digest": "fb2b417c2c7fb6f6f4de295511540690",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6.8",
"size": 5293,
"upload_time": "2023-09-06T11:04:51",
"upload_time_iso_8601": "2023-09-06T11:04:51.500494Z",
"url": "https://files.pythonhosted.org/packages/4d/34/f1e791cfe7c0a5f448dc5f72626e9b96b8ebaff210cda4e40821269a61b8/easy_excel_tool-1.0.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-09-06 11:04:51",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "easy-excel-tool"
}
JSON