Python read-write operations excel--install third-party libraries (XLRD, XLWT, Xlutils)

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)