<p align="center">
👉 <a target="_blank" href="https://www.python-office.com/">项目官网：https://www.python-office.com/</a> 👈
</p>
<p align="center">
👉 <a target="_blank" href="https://python-office-1300615378.cos.ap-chongqing.myqcloud.com/python-office.jpg">本开源项目的交流群</a> 👈
</p>
-------------------------------------------------------------------------------
## 📚简介
poexcel 是python自动化办公之Excel操作的第三方库。
来自于开源项目：python-office，[📘官网：https://www.python-office.com/](https://www.python-office.com/)。
-------------------------------------------------------------------------------
## 📦安装
### 🍊pip 自动下载&更新
```
pip install -i https://mirrors.aliyun.com/pypi/simple/ poexcel -U
```
-------------------------------------------------------------------------------
## 📝功能
已有功能的说明如下：
| 序号 | 方法名 | 功能 | 视频 | 文档 | 演示代码 |
|----|-----------------------|---------------------------------|---------------------------------------------------|-----------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 1 | fake2excel | 批量生成Excel数据 | [播放](https://www.bilibili.com/video/BV1wr4y1b7uk) | [查看]([待编辑](https://mp.weixin.qq.com/s/xVwEjXu58WovgSi4ZTtVQw)) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E6%89%B9%E9%87%8F%E6%A8%A1%E6%8B%9F%E6%95%B0%E6%8D%AE.py) |
| 2 | merge2excel | 合并多个Excel到一个Excel的不同sheet中 | [播放](https://www.bilibili.com/video/BV1714y147Ao) | [查看](https://mp.weixin.qq.com/s/3ZhZZfGlpNhszCWnOBeklg) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E5%90%88%E5%B9%B6%E5%A4%9A%E4%B8%AAExcel%E5%88%B0%E4%B8%80%E4%B8%AAExcel%E7%9A%84%E4%B8%8D%E5%90%8Csheet%E4%B8%AD.py) |
| 3 | sheet2excel | 同一个excel里的不同sheet，拆分为不同的excel文件 | [播放](https://www.bilibili.com/video/BV1714y147Ao) | [查看](https://mp.weixin.qq.com/s/dAx6JEbj5OlVnCcxokCzTQ) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E5%90%8C%E4%B8%80%E4%B8%AAexcel%E9%87%8C%E7%9A%84%E4%B8%8D%E5%90%8Csheet%EF%BC%8C%E6%8B%86%E5%88%86%E4%B8%BA%E4%B8%8D%E5%90%8C%E7%9A%84excel%E6%96%87%E4%BB%B6.py) |
| 4 | find_excel_data | 根据内容查询Excel | [播放](https://www.bilibili.com/video/BV1Bd4y1B7yr) | [查看](https://mp.weixin.qq.com/s/NAfh6ooO_9haALMsF8Jf5w) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E6%A0%B9%E6%8D%AE%E5%86%85%E5%AE%B9%EF%BC%8C%E6%9F%A5%E8%AF%A2Excel.py) |
| 5 | excel2pdf | Excel转PDF | [播放](https://www.bilibili.com/video/BV1A84y1N7or) | [查看](https://mp.weixin.qq.com/s/9cobekrIrR7BnUzfepv6Tg) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/Excel%E8%BD%ACPDF.py) |
| 6 | query4excel | 把100个Excel中符合条件的数据，汇总到1个Excel里 | [播放](https://www.bilibili.com/video/BV1Hs4y1S7TT) | 待编辑 | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E6%8A%8A100%E4%B8%AAExcel%E4%B8%AD%E7%AC%A6%E5%90%88%E6%9D%A1%E4%BB%B6%E7%9A%84%E6%95%B0%E6%8D%AE%EF%BC%8C%E6%B1%87%E6%80%BB%E5%88%B01%E4%B8%AAExcel%E9%87%8C.py) |
| 7 | count4page | 统计Excel打印出来有多少页 | 待录制 | [查看](https://blog.csdn.net/weixin_42321517/article/details/131218163) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E7%BB%9F%E8%AE%A1Excel%E6%89%93%E5%8D%B0%E5%87%BA%E6%9D%A5%E6%9C%89%E5%A4%9A%E5%B0%91%E9%A1%B5.py) |
| 8 | merge2sheet | 统计Excel打印出来有多少页 | 待录制 | 待编辑 | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/合并2个Excel的内容到一个sheet中.py) |
| 9 | split_excel_by_column | 根据指定的列，拆分Excel到不同的sheet | 待录制 | 待编辑 | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/根据指定的列，拆分excel.py) |
## 🏗️添砖加瓦
本项目欢迎任何人参与开发，如果是小白，可以看一下开发教程👉[如何参与开源项目？0基础入门：怎么打开GitHub？什么是issue？什么是PR？](https://www.bilibili.com/video/BV1EP411d7Np/?spm_id_from=333.999.0.0)
### 🐞提供bug反馈或建议
提交问题反馈时，请务必填写和该项目本身有关的问题，不进行有关python学习，甚至是个人练习的知识答疑和讨论。
- [Github issue](https://github.com/CoderWanFeng/poexcel/issues)
- [gitee issue](https://gitee.com/CoderWanFeng/poexcel/issues)
### 🧬贡献代码的步骤
1. 在Gitee或者Github上fork项目到自己的repo
2. 把fork过去的项目也就是你的项目clone到你的本地
3. 修改代码
4. commit后push到自己的库
5. 登录Gitee或Github在你首页可以看到一个 pull request 按钮，点击它，填写一些说明信息，然后提交到master分支即可。
6. 等待程序员晚枫合并，＋微信说一声更好👉[CoderWanFeng](http://python4office.cn/wechat-qrcode/)
-------------------------------------------------------------------------------
## 📌联系作者
<p align="center" id='开源交流群-banner'>
<a target="_blank" href='https://python-office-1300615378.cos.ap-chongqing.myqcloud.com/python-office.jpg'>
<img src="https://python-office-1300615378.cos.ap-chongqing.myqcloud.com/python-office-qr.jpg" width="100%"/>
</a>
</p>
## 读者福利
几个没有套路的福利，每天都可以领一次~
<p align="center" id='福利合集-banner'>
<a target="_blank" href='http://python4office.cn/sideline-pro-list/'>
<img src="https://python-office-1300615378.cos.ap-chongqing.myqcloud.com/fuli.jpg" width="100%"/>
</a>
</p>
Raw data
{
"_id": null,
"home_page": "https://www.python-office.com/",
"name": "poexcel",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "",
"keywords": "",
"author": "CoderWanFeng",
"author_email": "1957875073@qq.com",
"download_url": "https://files.pythonhosted.org/packages/ac/f1/e9efa8cf0aede8990d78df07cc29b7bb43c54be82b6562f51cc094f5aca2/poexcel-0.0.22.tar.gz",
"platform": "any",
"description": "<p align=\"center\">\r\n\t\ud83d\udc49 <a target=\"_blank\" href=\"https://www.python-office.com/\">\u9879\u76ee\u5b98\u7f51\uff1ahttps://www.python-office.com/</a> \ud83d\udc48\r\n</p>\r\n<p align=\"center\">\r\n\t\ud83d\udc49 <a target=\"_blank\" href=\"https://python-office-1300615378.cos.ap-chongqing.myqcloud.com/python-office.jpg\">\u672c\u5f00\u6e90\u9879\u76ee\u7684\u4ea4\u6d41\u7fa4</a> \ud83d\udc48\r\n</p>\r\n\r\n\r\n\r\n-------------------------------------------------------------------------------\r\n\r\n## \ud83d\udcda\u7b80\u4ecb\r\n\r\npoexcel \u662fpython\u81ea\u52a8\u5316\u529e\u516c\u4e4bExcel\u64cd\u4f5c\u7684\u7b2c\u4e09\u65b9\u5e93\u3002\r\n\r\n\u6765\u81ea\u4e8e\u5f00\u6e90\u9879\u76ee\uff1apython-office\uff0c[\ud83d\udcd8\u5b98\u7f51\uff1ahttps://www.python-office.com/](https://www.python-office.com/)\u3002\r\n\r\n-------------------------------------------------------------------------------\r\n\r\n## \ud83d\udce6\u5b89\u88c5\r\n\r\n### \ud83c\udf4apip \u81ea\u52a8\u4e0b\u8f7d&\u66f4\u65b0\r\n\r\n```\r\npip install -i https://mirrors.aliyun.com/pypi/simple/ poexcel -U\r\n```\r\n\r\n-------------------------------------------------------------------------------\r\n\r\n## \ud83d\udcdd\u529f\u80fd\r\n\r\n\u5df2\u6709\u529f\u80fd\u7684\u8bf4\u660e\u5982\u4e0b\uff1a\r\n\r\n| \u5e8f\u53f7 | \u65b9\u6cd5\u540d | \u529f\u80fd | \u89c6\u9891 | \u6587\u6863 | \u6f14\u793a\u4ee3\u7801 |\r\n|----|-----------------------|---------------------------------|---------------------------------------------------|-----------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\r\n| 1 | fake2excel | \u6279\u91cf\u751f\u6210Excel\u6570\u636e | [\u64ad\u653e](https://www.bilibili.com/video/BV1wr4y1b7uk) | [\u67e5\u770b]([\u5f85\u7f16\u8f91](https://mp.weixin.qq.com/s/xVwEjXu58WovgSi4ZTtVQw)) | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E6%89%B9%E9%87%8F%E6%A8%A1%E6%8B%9F%E6%95%B0%E6%8D%AE.py) |\r\n| 2 | merge2excel | \u5408\u5e76\u591a\u4e2aExcel\u5230\u4e00\u4e2aExcel\u7684\u4e0d\u540csheet\u4e2d | [\u64ad\u653e](https://www.bilibili.com/video/BV1714y147Ao) | [\u67e5\u770b](https://mp.weixin.qq.com/s/3ZhZZfGlpNhszCWnOBeklg) | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E5%90%88%E5%B9%B6%E5%A4%9A%E4%B8%AAExcel%E5%88%B0%E4%B8%80%E4%B8%AAExcel%E7%9A%84%E4%B8%8D%E5%90%8Csheet%E4%B8%AD.py) |\r\n| 3 | sheet2excel | \u540c\u4e00\u4e2aexcel\u91cc\u7684\u4e0d\u540csheet\uff0c\u62c6\u5206\u4e3a\u4e0d\u540c\u7684excel\u6587\u4ef6 | [\u64ad\u653e](https://www.bilibili.com/video/BV1714y147Ao) | [\u67e5\u770b](https://mp.weixin.qq.com/s/dAx6JEbj5OlVnCcxokCzTQ) | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E5%90%8C%E4%B8%80%E4%B8%AAexcel%E9%87%8C%E7%9A%84%E4%B8%8D%E5%90%8Csheet%EF%BC%8C%E6%8B%86%E5%88%86%E4%B8%BA%E4%B8%8D%E5%90%8C%E7%9A%84excel%E6%96%87%E4%BB%B6.py) |\r\n| 4 | find_excel_data | \u6839\u636e\u5185\u5bb9\u67e5\u8be2Excel | [\u64ad\u653e](https://www.bilibili.com/video/BV1Bd4y1B7yr) | [\u67e5\u770b](https://mp.weixin.qq.com/s/NAfh6ooO_9haALMsF8Jf5w) | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E6%A0%B9%E6%8D%AE%E5%86%85%E5%AE%B9%EF%BC%8C%E6%9F%A5%E8%AF%A2Excel.py) |\r\n| 5 | excel2pdf | Excel\u8f6cPDF | [\u64ad\u653e](https://www.bilibili.com/video/BV1A84y1N7or) | [\u67e5\u770b](https://mp.weixin.qq.com/s/9cobekrIrR7BnUzfepv6Tg) | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/Excel%E8%BD%ACPDF.py) |\r\n| 6 | query4excel | \u628a100\u4e2aExcel\u4e2d\u7b26\u5408\u6761\u4ef6\u7684\u6570\u636e\uff0c\u6c47\u603b\u52301\u4e2aExcel\u91cc | [\u64ad\u653e](https://www.bilibili.com/video/BV1Hs4y1S7TT) | \u5f85\u7f16\u8f91 | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E6%8A%8A100%E4%B8%AAExcel%E4%B8%AD%E7%AC%A6%E5%90%88%E6%9D%A1%E4%BB%B6%E7%9A%84%E6%95%B0%E6%8D%AE%EF%BC%8C%E6%B1%87%E6%80%BB%E5%88%B01%E4%B8%AAExcel%E9%87%8C.py) |\r\n| 7 | count4page | \u7edf\u8ba1Excel\u6253\u5370\u51fa\u6765\u6709\u591a\u5c11\u9875 | \u5f85\u5f55\u5236 | [\u67e5\u770b](https://blog.csdn.net/weixin_42321517/article/details/131218163) | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/%E7%BB%9F%E8%AE%A1Excel%E6%89%93%E5%8D%B0%E5%87%BA%E6%9D%A5%E6%9C%89%E5%A4%9A%E5%B0%91%E9%A1%B5.py) |\r\n| 8 | merge2sheet | \u7edf\u8ba1Excel\u6253\u5370\u51fa\u6765\u6709\u591a\u5c11\u9875 | \u5f85\u5f55\u5236 | \u5f85\u7f16\u8f91 | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/\u5408\u5e762\u4e2aExcel\u7684\u5185\u5bb9\u5230\u4e00\u4e2asheet\u4e2d.py) |\r\n| 9 | split_excel_by_column | \u6839\u636e\u6307\u5b9a\u7684\u5217\uff0c\u62c6\u5206Excel\u5230\u4e0d\u540c\u7684sheet | \u5f85\u5f55\u5236 | \u5f85\u7f16\u8f91 | [\u6253\u5f00](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/\u6839\u636e\u6307\u5b9a\u7684\u5217\uff0c\u62c6\u5206excel.py) |\r\n\r\n## \ud83c\udfd7\ufe0f\u6dfb\u7816\u52a0\u74e6\r\n\r\n\u672c\u9879\u76ee\u6b22\u8fce\u4efb\u4f55\u4eba\u53c2\u4e0e\u5f00\u53d1\uff0c\u5982\u679c\u662f\u5c0f\u767d\uff0c\u53ef\u4ee5\u770b\u4e00\u4e0b\u5f00\u53d1\u6559\u7a0b\ud83d\udc49[\u5982\u4f55\u53c2\u4e0e\u5f00\u6e90\u9879\u76ee\uff1f0\u57fa\u7840\u5165\u95e8\uff1a\u600e\u4e48\u6253\u5f00GitHub\uff1f\u4ec0\u4e48\u662fissue\uff1f\u4ec0\u4e48\u662fPR\uff1f](https://www.bilibili.com/video/BV1EP411d7Np/?spm_id_from=333.999.0.0)\r\n\r\n### \ud83d\udc1e\u63d0\u4f9bbug\u53cd\u9988\u6216\u5efa\u8bae\r\n\r\n\u63d0\u4ea4\u95ee\u9898\u53cd\u9988\u65f6\uff0c\u8bf7\u52a1\u5fc5\u586b\u5199\u548c\u8be5\u9879\u76ee\u672c\u8eab\u6709\u5173\u7684\u95ee\u9898\uff0c\u4e0d\u8fdb\u884c\u6709\u5173python\u5b66\u4e60\uff0c\u751a\u81f3\u662f\u4e2a\u4eba\u7ec3\u4e60\u7684\u77e5\u8bc6\u7b54\u7591\u548c\u8ba8\u8bba\u3002\r\n\r\n- [Github issue](https://github.com/CoderWanFeng/poexcel/issues)\r\n- [gitee issue](https://gitee.com/CoderWanFeng/poexcel/issues)\r\n### \ud83e\uddec\u8d21\u732e\u4ee3\u7801\u7684\u6b65\u9aa4\r\n\r\n1. \u5728Gitee\u6216\u8005Github\u4e0afork\u9879\u76ee\u5230\u81ea\u5df1\u7684repo\r\n2. \u628afork\u8fc7\u53bb\u7684\u9879\u76ee\u4e5f\u5c31\u662f\u4f60\u7684\u9879\u76eeclone\u5230\u4f60\u7684\u672c\u5730\r\n3. \u4fee\u6539\u4ee3\u7801\r\n4. commit\u540epush\u5230\u81ea\u5df1\u7684\u5e93\r\n5. \u767b\u5f55Gitee\u6216Github\u5728\u4f60\u9996\u9875\u53ef\u4ee5\u770b\u5230\u4e00\u4e2a pull request \u6309\u94ae\uff0c\u70b9\u51fb\u5b83\uff0c\u586b\u5199\u4e00\u4e9b\u8bf4\u660e\u4fe1\u606f\uff0c\u7136\u540e\u63d0\u4ea4\u5230master\u5206\u652f\u5373\u53ef\u3002\r\n6. \u7b49\u5f85\u7a0b\u5e8f\u5458\u665a\u67ab\u5408\u5e76\uff0c\uff0b\u5fae\u4fe1\u8bf4\u4e00\u58f0\u66f4\u597d\ud83d\udc49[CoderWanFeng](http://python4office.cn/wechat-qrcode/)\r\n\r\n-------------------------------------------------------------------------------\r\n\r\n## \ud83d\udccc\u8054\u7cfb\u4f5c\u8005\r\n\r\n<p align=\"center\" id='\u5f00\u6e90\u4ea4\u6d41\u7fa4-banner'>\r\n<a target=\"_blank\" href='https://python-office-1300615378.cos.ap-chongqing.myqcloud.com/python-office.jpg'>\r\n<img src=\"https://python-office-1300615378.cos.ap-chongqing.myqcloud.com/python-office-qr.jpg\" width=\"100%\"/>\r\n</a> \r\n</p>\r\n\r\n## \u8bfb\u8005\u798f\u5229\r\n\r\n\u51e0\u4e2a\u6ca1\u6709\u5957\u8def\u7684\u798f\u5229\uff0c\u6bcf\u5929\u90fd\u53ef\u4ee5\u9886\u4e00\u6b21~\r\n\r\n<p align=\"center\" id='\u798f\u5229\u5408\u96c6-banner'>\r\n <a target=\"_blank\" href='http://python4office.cn/sideline-pro-list/'>\r\n <img src=\"https://python-office-1300615378.cos.ap-chongqing.myqcloud.com/fuli.jpg\" width=\"100%\"/>\r\n </a> \r\n</p>\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "pip install poexcel",
"version": "0.0.22",
"project_urls": {
"Bug Tracker": "https://github.com/CoderWanFeng/poexcel/issues",
"Documentation": "https://github.com/CoderWanFeng/poexcel/blob/master/README.md",
"Homepage": "https://www.python-office.com/",
"Source Code": "https://github.com/CoderWanFeng/poexcel"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "2abb0a2a5e7c7280e05daf525c4afbcb4819dac82b5eb730bf020811ae4146c5",
"md5": "9944258efadd3969e30320a1cbac08aa",
"sha256": "1fa24fcaabd051cdcc6753b0a63147150698247a84739a48c1ce32e8b65ea039"
},
"downloads": -1,
"filename": "poexcel-0.0.22-py3-none-any.whl",
"has_sig": false,
"md5_digest": "9944258efadd3969e30320a1cbac08aa",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 14655,
"upload_time": "2024-03-02T06:55:35",
"upload_time_iso_8601": "2024-03-02T06:55:35.670427Z",
"url": "https://files.pythonhosted.org/packages/2a/bb/0a2a5e7c7280e05daf525c4afbcb4819dac82b5eb730bf020811ae4146c5/poexcel-0.0.22-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "acf1e9efa8cf0aede8990d78df07cc29b7bb43c54be82b6562f51cc094f5aca2",
"md5": "41b262154b0c7f4484c1725c048b3683",
"sha256": "e8952147348c298477c8b02fcbea39d1e59eb2cca6503992f8a660f788bc7648"
},
"downloads": -1,
"filename": "poexcel-0.0.22.tar.gz",
"has_sig": false,
"md5_digest": "41b262154b0c7f4484c1725c048b3683",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 14795,
"upload_time": "2024-03-02T06:55:37",
"upload_time_iso_8601": "2024-03-02T06:55:37.571174Z",
"url": "https://files.pythonhosted.org/packages/ac/f1/e9efa8cf0aede8990d78df07cc29b7bb43c54be82b6562f51cc094f5aca2/poexcel-0.0.22.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-03-02 06:55:37",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "CoderWanFeng",
"github_project": "poexcel",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "poexcel"
}
JSON
