To operate Excel and MySQL first need to install Python, then install Excel and MySQL plugin;
The first step is to install Python;
Direct Baidu Search, download installation can be.
The second step installs the Excel plugin;
First to this http://pypi.python.org/pypi/xlrd URL download plugin;
Because this website opens slowly (domestic opens the common disease of the foreign website), can go to my this network disk to download: download
After downloading, unzip to a fixed directory, for example: I extract to d:\excel under
Then press CTRL + C to open run CMD into the decompression directory (the default is the C drive, enter the D drive can be directly input D:)
Go to unzip directory: d:\excel\xlrd-0.9.4 directory. Enter the command python setup.py install.
The third step installs the MySQL plugin;
Official: http://dev.mysql.com/downloads/connector/python/: Download
After downloading, as long as the next step, it is very simple.
Finally, how to determine whether Excel and MySQL plugin installed successfully, directly open the idle environment.
Enter Import pymysql,xlrd
As long as the error is not indicated, the installation is successful.
Here, the pre-environment is ready.
Continue next time
Compare (i)-win environment preparation by reading Excel data and MySQL database data