Data processing is a great application of Python, while Excel is the most popular data processing software. So when it comes to data-related work with Python, it's hard to deal with Excel.
If you just want to save your data as a form, you can work with it in CSV format (a comma-delimited tabular data format), which Excel supports. However, the standard Excel file (XLS/XLSX) has a more complex format and is not easy to read and write directly like a normal text file, and it needs to be implemented with a third-party library.
The common library is the Python-excel series:
XLRD, XLWT, xlutils
XLRD-Read Excel file
XLWT-writing to an Excel file
Xlutils-Utilities for working with Excel files, such as copying, splitting, filtering, etc.
Installation
1.:
https://pypi.python.org/pypi/xlrd/1.1.0
https://pypi.python.org/pypi/xlwt/1.3.0
https://pypi.python.org/pypi/xlutils/2.0.0
2. Installation
2.1, installation of XLRD,
Method One:
Switch to the source file, execute the command python setup.py install
After success will add XLRD folders and files under Site-packages
2.2, Installation XLWT
Method Two:
Switch to the source file, execute the command pip install XLWT-1.3.0-PY2.PY3-NONE-ANY.WHL
After successful installation, the XLWT folder and files will be added under Site-packages.
2.3, Installation Xlutils
Switch to the source file, execute the command pip install XLUTILS-2.0.0-PY2.PY3-NONE-ANY.WHL
After successful installation, the Xlutils folder and files will be added under Site-packages.
Python read-write operations excel--install third-party libraries (XLRD, XLWT, Xlutils)