Excel数据导入sqlite3

#-*- 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()