Read and write Excel under Windows python

Refer to a lot of online experience sharing, after the test feel the best use is xlrd (read) +pyexcelerator (write). The installation process is similar, simple summary: Unpack the package, cmd in the Extract directory execution python setup.py install.

Refer to the following link for the specific course of operation: http://blog.csdn.net/menuconfig/article/details/8672963

About Pyexcelerator to remind you that the first time you create a workbook, add a worksheet, and then write to it until you specify that the table name is stored with the Save () method before the data is successfully written, the previous operation can be considered on a temporary table.

Read and write Excel under Windows python