Excel数据导入sqlite3

#-*- coding:utf-8-*-import sysreload(sys)sys.setdefaultencoding('utf-8')import sqlite3import xlrddef 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()