源码:
环境:win7
#!/usr/bin/python
#coding:gbk
print "你好"
import xlrd
import MySQLdb
import os
for fpathe,dirs,fs in os.walk("C:\\AAA\\python\\test4\\"):
for f in fs:
print os.path.join(fpathe,f)
filename = os.path.join(fpathe,f)
#读取EXCEL中内容到数据库中
#for j in subjects:
# print j
# print "我的"
wb = xlrd.open_workbook(filename)
sh = wb.sheet_by_index(0)
dfun=[]
nrows = sh.nrows #行数
ncols = sh.ncols #列数
fo=[]
fo.append(sh.row_values(0))
for i in range(1,nrows):
dfun.append(sh.row_values(i))
conn=MySQLdb.connect(host='localhost',user='user',passwd='password',db='my_schema')
cursor=conn.cursor()
conn.set_character_set(&