Comparison between reading excel Data and mysql database data (1)-win environment preparation, mysql-win

Source: Internet
Author: User

Comparison between reading excel Data and mysql database data (1)-win environment preparation, mysql-win

To operate excel and mysql, you must first install python, and then install the excel and mysql plug-ins;

Step 1 install python;

Search Baidu directly and download and install it.

Step 2 install the excel plug-in;

First download the plug-in at http://pypi.python.org/pypi/xlrdnet;

Because this website is slow to open (a common problem in China), you can download it from my online Disk: Download

After downloading, decompress the package to a fixed directory, for example, decompress it to d: \ excel.

Then press ctrl + c to open and run cmd to enter the decompressed directory (disk c is used by default, and disk d can be entered directly :)

Go to the extract Directory: d: \ excel \ xlrd-0.9.4 directory. Run python setup. py install to install python.

Step 3 install the mysql plug-in;

Official Website: http://dev.mysql.com/downloads/connector/python/:download

After the download, you only need to proceed to the next step, which is very simple.

Finally, how can I determine whether the excel and mysql plug-ins have been successfully installed and open the IDLE environment directly.

Enter import pymysql, xlrd

If no error is reported, the installation is successful.

At this point, the preliminary environment is ready.

Continue next time

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.