Python自动化办公的第三方库：pip install python-office

## 视频教程 <p align="center" id='进群-banner'> <a target="_blank" href='http://www.python4office.cn/wechat-group/'> <img src="https://website-python-1300615378.cos.ap-nanjing.myqcloud.com/%E5%BC%95%E5%AF%BC%E8%B6%85%E9%93%BE%E6%8E%A5%2F%E6%8A%80%E6%9C%AF%E7%BE%A4.jpg" width="100%"/> </a> </p> <p align="center" name="图标-github"> <a target="_blank" href='https://github.com/CoderWanFeng/python-office'> <img src="https://img.shields.io/github/stars/CoderWanFeng/python-office.svg?style=social" alt="github star"/> </a> <a target="_blank" href='https://gitee.com/CoderWanFeng/python-office'> <img src='https://gitee.com/CoderWanFeng//python-office/badge/star.svg?theme=dark' alt='gitee star'/> </a> <a href="https://mp.weixin.qq.com/s/yaSmFKO3RrBpyanW3nvRAQ"> <img src="https://img.shields.io/badge/QQ-163434413-orange"/> </a> <a href="https://mp.weixin.qq.com/s/NN2pX2bQPpczOeGF4ARNtw"> <img src="https://img.shields.io/badge/%E5%BE%AE%E4%BF%A1-%E4%BA%A4%E6%B5%81%E7%BE%A4-brightgreen"/> </a> </p> 以下[绿色](https://mp.weixin.qq.com/s/-mlsV7PFc27JElOTCskMsg)文字，均可点击直达👇持续更新中🚀 ## 0、下载和安装 | 序号 | 功能 | 视频 | 下载地址 | |----|------------|---------------------------------------------------|-----------------------------------------------------------| | 1 | ❤项目发布 | [播放](https://www.bilibili.com/video/BV1pT4y1k7FH) | [Python官网](https://pypi.org/project/python-office/) | | 2 | 安装python环境 | [播放](https://www.bilibili.com/video/BV1Q44y1u7rV) | [下载软件](https://mp.weixin.qq.com/s/ktmQafdstwep_A5vae_Ymw) | ## 1、Word + 自动化办公 = poword | 序号 | 方法名 | 功能 | 视频 | 文档 | 演示代码 | |----|-------------------|---------------|---------------------------------------------------|---------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------| | 1 | merge4docx | 合并Word文档 | [播放](https://www.bilibili.com/video/BV1Vo4y1q7i3) | [查看](https://mp.weixin.qq.com/s/PjQJ3s4Arr872NDfcr-7YA) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poword/%E5%90%88%E5%B9%B6word.py) | | 2 | docx2doc/doc2docx | doc和docx，互相转换 | [播放](https://www.bilibili.com/video/BV1so4y1H7rj) | [查看](https://mp.weixin.qq.com/s/nyg_LlkHPwx1AY7wCg5KTw) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poword/doc%E5%92%8Cdocx%E4%BA%92%E8%BD%AC.py) | | 3 | docx2pdf | word 转 pdf | [播放](https://www.bilibili.com/video/BV1pT4y1k7FH) | [查看](https://mp.weixin.qq.com/s/Kfmu8vCSr6otGfrf7mj0bA) | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poword/word%E8%BD%ACPDF.py) | ## 2、Excel + 自动化办公 = poexcel | 序号 | 方法名 | 功能 | 视频 | 文档 | 演示代码 | |----|-----------------------|---------------------------------|---------------------------------------------------|-----------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | 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://mp.weixin.qq.com/s/TmglyiAILV5k6Een6EnqtA) | [打开](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 | 多个sheet，根据指定的列，合并成1个 | 待录制 | 待编辑 | [打开](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/合并2个Excel的内容到一个sheet中.py) | | 9 | split_excel_by_column | 根据指定的列，拆分Ex