python Excel 写的操作

python 在做Excel读写操做的时候需要 先在dos命令下 输入：pip install xlwt(这是用来写的)       pip install xlrd(这是用来读的)

今天主要把数据库里面的东西查了出来遍历 然后写到了Excel里面

# -*- coding:utf8 -*-
import os
import sys
# import django
# import oss2
# from PIL import Image
import xlwt


from zhudb import *
from zhu_outlets_class import *

wh=2


if __name__ == "__main__":

    # 创建工作簿
    book = xlwt.Workbook()
    # 创建表单
    booksheet = book.add_sheet(u'sheet1', cell_overwrite_ok=True)

    from zhudb import create_outlets_session
    goods_session=create_outlets_session()

    x=0
    y=0
    goodslist=goods_session.query(outlets_goods).filter(outlets_goods.warehouseid==wh)\
        .filter(outlets_goods.sourcestatus==1).all()
    for one in goodslist:
        goods_speclist = goods_session.query(outlets_goods_spec).filter(outlets_goods_spec.goodsid == one.id).all()
        print one.id, one.title
        if len(goods_speclist) == 2:
            booksheet.write(y,x,one.title)

            y+=1
            #保存文件
    book.save(u'D:\zhu\\temp\\title.xls')