#-*- coding:utf-8-*-
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
import sqlite3
import xlrd
def excel_read_and_deal(file):
data=xlrd.open_workbook(file)
table=data.sheet_by_name('Sheet1')
nRow=table.nrows
for i in range(nRow):
print table.row_values(i)[0]
importsqlite3(table.row_values(i)[0])
def importsqlite3(value):
conn=sqlite3.connect('db.sqlite3')
sql = '''insert into cmdb_blacklists (origin_word) values ("%s")''' %(value)
# sql = ''' select * from cmdb_blacklists'''
print sql
cursors=conn.cursor()
cursors.execute(sql)
conn.commit()
if __name__=='__main__':
file='./test.xlsx'
excel_read_and_deal(file)
注意,在python中执行数据库语言千万不要忘记commit()