python链接数据库生成Excel

模块安装

$ pip install xlwt

先来个简单的例子:

#链接数据库
#懒得写，自己找
class User(db.Model):
    __tablename__ = 'user_table'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(40))
    email = db.Column(db.String(40))
    phone = db.Column(db.String(40))
    passwd = db.Column(db.String(40))
def get_excel():
    workbook = xlwt.Workbook(encoding = 'ascii')
    worksheet = workbook.add_sheet('My Worksheet',cell_overwrite_ok=True)
    style = xlwt.XFStyle() # 初始化样式
    font = xlwt.Font() # 为样式创建字体
    font.name = 'Times New Roman'
    font.bold = True # 黑体
    font.underline = True # 下划线
    font.italic = True # 斜体字
    style.font = font
    user = User.query.all()#flask查询数据库
    for a in range(len(user)):
        worksheet.write(a, 0,user[a].id )
        worksheet.write(a, 1, user[a].name)
        worksheet.write(a,2, user[a].email)
        worksheet.write(a, 3, user[a].phone)
        worksheet.write(a, 4, user[a].passwd)
        worksheet.col(1).width = 8000
        worksheet.col(2).width = 8000
        worksheet.col(3).width = 8000
        worksheet.col(4).width = 8000
        workbook.save(user_table)#保存路径