python mysql insert into_Python 读取Excel insert into mysql

需要软件

1. xlrd

官方资料：

下载地址：http://pypi.python.org/pypi/xlrd

官网地址：http://www.python-excel.org/

文档地址:https://secure.simplistix.co.uk/svn/xlrd/trunk/xlrd/doc/xlrd.html

文档pdf下载：http://www.simplistix.co.uk/presentations/python-excel.pdf

2. mysqldb

示例代码:

#encoding: utf-8

'''

Created on 2012-9-4

将Excel导入到数据库

@author: 蓝桥书生

'''

import MySQLdb

import xlrd

import datetime

def insert(cursor,sql):

print cursor.execute(sql)

if __name__ == '__main__':

db = MySQLdb.connect(user='root', db='tinnonjscm', passwd='root', host='localhost')

cursor = db.cursor()

xlsfile = r'E:\tmp\projectMgr_project.xls'

book = xlrd.open_workbook(xlsfile)

sheet1 = book.sheet_by_index(0)

nrows = sheet1.nrows #行总数

for row in range(nrows):

sql = "insert into projectmgr_project (name) VALUES('"+sheet1.cell_value(row,1)+"')";

print sql

insert(cursor,sql)

db.commit()

cursor.close()

db.close()