Python自动化办公的第三方库.zip

## 视频教程 <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/_01V8I7rVkgvIIo7ygwwQA)文字，均可点击直达👇持续更新中🚀 ## 0、下载和安装 | 功能 | 视频（文档） | 下载地址 | | -------------- | --------------------------------------------------- | ------------------------------------------------------------- | | ❤项目发布 | [视频](https://www.bilibili.com/video/BV1pT4y1k7FH) | [Python官网](https://pypi.org/project/python-office/) | | 安装python环境 | [视频](https://www.bilibili.com/video/BV1Q44y1u7rV) | [下载软件](https://mp.weixin.qq.com/s/ktmQafdstwep_A5vae_Ymw) | ## 1、Word + 自动化办公 = poword | 方法名 | 功能 | 视频（文档） | 演示代码 | | ----------------- | ------------------- | --------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------- | | merge4docx | 合并Word文档 | [视频](https://www.bilibili.com/video/BV1Vo4y1q7i3) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/poword/%E5%90%88%E5%B9%B6word.py) | | docx2doc/doc2docx | doc和docx，互相转换 | [视频](https://www.bilibili.com/video/BV1so4y1H7rj) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/poword/doc%E5%92%8Cdocx%E4%BA%92%E8%BD%AC.py) | | docx2pdf | word 转 pdf | [视频](https://www.bilibili.com/video/BV1pT4y1k7FH) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/poword/word%E8%BD%ACPDF.py) | ## 2、Excel + 自动化办公 | 方法名 | 功能 | 视频（文档） | 演示代码 | | --------------- | ----------------------------------------------- | ----------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------- | | fake2excel | 批量生成Excel数据 | [视频](https://www.bilibili.com/video/BV1wr4y1b7uk) | [源码](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) | | merge2excel | 合并多个Excel到一个Excel的不同sheet中 | [视频](https://www.bilibili.com/video/BV1714y147Ao) | [源码](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) | | sheet2excel | 同一个excel里的不同sheet，拆分为不同的excel文件 | [视频](https://www.bilibili.com/video/BV1714y147Ao) | [源码](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) | | find_excel_data | 根据内容查询Excel | [视频](https://www.bilibili.com/video/BV1Bd4y1B7yr) | [源码](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) | | excel2pdf | Excel转PDF | [视频](https://www.bilibili.com/video/BV1A84y1N7or) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/poexcel/Excel%E8%BD%ACPDF.py) | | 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) | | 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) | ## 3、PDF + 自动化办公 | 方法名 | 功能 | 视频（文档） | 演示代码 | | ------------- | ------------ | ----------------------------------------------------------------------- | --------------------------------------------------------- | | add_watermark | PDF加水印 | [视频](https://www.bilibili.com/video/BV1Se411T7au) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/popdf/PDF%E5%8A%A0%E6%B0%B4%E5%8D%B0.py) | | txt2pdf | TXT转PDF | [文档](https://blog.csdn.net/weixin_42321517/article/details/130612189) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/popdf/TXT%E8%BD%ACPDF.py) | | encrypt4pdf | PDF加密 | [文档](https://blog.csdn.net/weixin_42321517/article/details/129963432) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/popdf/PDF%E5%8A%A0%E5%AF%86.py) | | decrypt4pdf | PDF解密 | [文档](https://mp.weixin.qq.com/s/GiXYB_xZdlsYv5AIeIELkA) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/popdf/PDF%E8%A7%A3%E5%AF%86.py) | | merge2pdf | 合并PDF | [文档](https://baijiahao.baidu.com/s?id=1733062611567959337) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/popdf/%E5%90%88%E5%B9%B6PDF.py) | | pdf2docx | 💻PDF 转 Word | 💻[视频](https://www.bilibili.com/video/BV19D4y1i7Eu) | [源码](https://github.com/CoderWanFeng/python-office/blob/master/demo/popdf/pdf%E8%BD