# -*- coding: utf-8 -*-
#将excle表中的数据导入mysql数据库中
import MySQLdb
import os
for ex in li:
db = MySQLdb.connect("localhost", "root", "123456", "excle", charset='utf8') #连接数据库
cursor = db.cursor()
sql = "insert into sheet2 values(%s,%s,%s,%s,%s,%s,%s,%s)"
for r in range(4,sheet.nrows):
#将excle表中的数据导入mysql数据库中
import MySQLdb
import os
import xlrd
li = ["2013年xxx公示表"]
#定义列表存放表文件名for ex in li:
lj = r"C:\内网通接受的文件\28_3_2_1\{}.xls".format(ex) #路径
book = xlrd.open_workbook(unicode(lj,"utf-8"))#打开excle表
b = str(ex).split(",")[0]
sheet = book.sheet_by_index(0)#按索引获取表也可以按名字获取book.sheet_by_name()
db = MySQLdb.connect("localhost", "root", "123456", "excle", charset='utf8') #连接数据库
cursor = db.cursor()
sql = "insert into sheet2 values(%s,%s,%s,%s,%s,%s,%s,%s)"
for r in range(4,sheet.nrows):