Want to use Python to manipulate Excel, see the data is said to OPENPYXL very useful, so to HTTPS://PYPI.PYTHON.ORG/PYPI/OPENPYXL downloaded the installation package. The following is the installation procedure, but also a memo to their own operations.
1, install Python (step): https://www.python.org/downloads/windows/
2, download OPENPYXL, address https://pypi.python.org/packages/source/o/openpyxl/openpyxl-2.3.1.tar.gz
3, decompression openpyxl-2.3.1.tar.gz to any directory. such as python/openpyxl-2.3.1
4, CMD window to the python/openpyxl-2.3.1 directory, locate the setup.py file, enter under command line: Python setup.py install enter.
5, the whole process without intervention, waiting for the appearance of finished processing dependencies for openpyxl==2.3.1, indicating the successful installation.
6, testing, in the Python environment input
>>>import OPENPLYXL
>>>help (OPENPYXL)
Appear
Installation is successful!
Win7 under Installation OPENPYXL