Python库将数据从sqlite导入word doc

Sqlite是Python标准库的一部分。这里有一个链接到 concise tutorial 以下是简短摘录:

import sqlite3
conn = sqlite3.connect('sqlite_file')
c = conn.cursor()

# Create a table
c.execute('CREATE TABLE {tn} ({nf} {ft})'\
    .format(tn='my_table', nf='name', ft='VARCHAR'))

conn.commit()
# insert table
c.execute("INSERT INTO {tn} ({cn}) VALUES ('test')".\
    format(tn='my_table', cn='name'))
conn.commit()
# select rows
c.execute('SELECT * FROM {tn}'.format(tn='my_table'))
all_rows = c.fetchall()

for row in all_rows:
    # do something