python excel

python 利用 xlwt  导出excel

 选择 xlwt ，进入 https://pypi.python.org/pypi/xlwt 进行下载安装

#!/usr/bin/python
#-*-coding:gbk-*-

import xlwt

import re
import logging
import string
import db


def createExcel():
    wbk = xlwt.Workbook()
    sheet  = wbk.add_sheet(u'sheet1')
    createXLSTitle(sheet) 
    for i in range(10):
        createXLS(sheet, i)
    wbk.save("c:/t1.xls")
    
def createXLSTitle(sheet):
    sheet.write(0,0,u"公司名称")
    sheet.write(0,1,u"会员年限")
    sheet.write(0,2,u"主营行业")
def createXLS(sheet,int):
    a = int+1
    sheet.write(a,0,u"厂家")
    sheet.write(a,1,u"会adfa")
    sheet.write(a,2,u"主adfads行业")
    
if __name__ == '__main__':
    createExcel()