# python4office

**Repository Path**: binbin0915_admin/python4office

## Basic Information

- **Project Name**: python4office
- **Description**: Python自动化办公学习指南。
- **Primary Language**: Python
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 20
- **Created**: 2022-08-16
- **Last Updated**: 2022-08-16

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Python自动化办公学习指南

### 项目介绍
本项目旨在整理所有Python + 自动化办公的技术资料。
创建人：[程序员晚枫](https://mp.weixin.qq.com/s/brapCp8aZxIOjgE8qLWs3A) ， 个人网站：www.python4office.cn
欢迎大家提交PR（pull request），一起来丰富这个项目！

### 主要内容

#### Excel
Python操作Excel的库最多，一共有9个~
- [Python操作Excel的9个库，你觉得哪个更好呢？](https://mp.weixin.qq.com/s/elkIG3doSityx2n0AmjT_Q)
- 参考资料：https://www.python-excel.org/
------
- xlrd
    - [下载](https://pypi.org/project/xlrd/)
    - [文字教程](http://xlrd.readthedocs.io/en/latest/)
    - [视频教程](https://www.bilibili.com/video/BV1y54y1i78U?p=13)
- xlwt
    - [下载](https://pypi.python.org/pypi/xlwt)
    - [文字教程](https://xlwt.readthedocs.io/en/latest/)
    - [视频教程](https://www.bilibili.com/video/BV1y54y1i78U?p=13)
- xlutils
    - [下载](https://pypi.python.org/pypi/xlutils)
    - [文字教程](https://xlutils.readthedocs.io/en/latest/)
    - [视频教程](https://www.bilibili.com/video/BV1y54y1i78U?p=14)
- xlwings
    - [下载](https://pypi.org/project/xlwings/)
    - [文字教程](https://docs.xlwings.org/en/stable/)
    - [视频教程](https://www.bilibili.com/video/BV1my4y1x7NQ)
- openpyxl
    - [下载](https://pypi.python.org/pypi/openpyxl)
    - [文字教程](https://openpyxl.readthedocs.io/en/stable/)
    - [视频教程](https://www.bilibili.com/video/BV1eM4y1A7JR)
- xlswriter
    - [下载](https://pypi.python.org/pypi/XlsxWriter)
    - [文字教程](https://xlsxwriter.readthedocs.io/)
    - [视频教程](https://www.bilibili.com/video/BV1y54y1i78U?p=18)
- pandas
    - [下载]()
    - [文字教程](https://pandas.pydata.org/)
    - [视频教程](https://www.bilibili.com/video/BV1hk4y1C73S)
- PyXLL
    - [下载](https://www.pyxll.com/download.html)
    - [文字教程](https://mp.weixin.qq.com/s/eczI5fe2xg42563ksDGcxA)
- 拓展
    - Go语言处理Excel：https://github.com/qax-os/excelize
#### Word

- python-docx
    - [下载](http://pypi.python.org/pypi/python-docx)
    - [文字教程](https://python-docx.readthedocs.io/en/latest/)
    - [视频教程](https://www.bilibili.com/video/BV1hy4y187eQ)

#### PPT

- python-pptx
    - [下载](http://pypi.python.org/pypi/python-pptx)
    - [文字教程](https://python-pptx.readthedocs.io/en/latest/)
    - [视频教程](https://www.bilibili.com/video/BV1564y127Ws)

#### PDF

- [PyPDF2](https://www.bilibili.com/video/BV18V411J7Cy)
    - [下载](https://pypi.org/project/PyPDF2/)
    - [文字教程](https://pypdf2.readthedocs.io/en/latest/)
    - [视频教程](https://www.bilibili.com/video/BV18V411J7Cy)

#### 爬虫

- scrapy
    - [文字教程](https://scrapy.org/)
    - [视频教程](https://www.bilibili.com/video/BV1LV411m7Ym)

#### 网站开发
- django
    - [文字教程](https://www.djangoproject.com/)
    - [视频教程](https://mp.weixin.qq.com/s/2BPiuy_gRA4j6CTWG7jVtQ)

#### 数据分析 & 数据可视化
- pandas
    - [下载]()
    - [文字教程](https://pandas.pydata.org/)
    - [视频教程](https://www.bilibili.com/video/BV1hk4y1C73S)
#### 个人网站
- hexo
    - [中文文档](https://hexo.io/zh-cn/)

#### 拓展技术