Python ---生成excel文件

#-*- utf:8 -*-

import xlsxwriter

# 新建一个Excel文件

workbook = xlsxwriter.Workbook(u'd:\interfaceresult.xlsx')

# 新建一个worksheet

worksheet = workbook.add_worksheet()

title = [u'测试用例',u'测试结果']

# 向'A1'单元格写入title列表，列表中每一个字段对应一列内容

worksheet.write_row(0,0,title)

t =[u'数据1',u'数据2']

worksheet.write_row(1,0,t)  #write_row(行,列,t)

workbook.close()

 

封装代码：

import xlsxwriter

class SaveFile(object):
    def __init__(self,sheetname):       #sheetname 页签名称