python使用xlwt将数据保存到excel文件中
#coding=utf-8
import xlwt
if __name__ == "__main__":
#创建样式
style = xlwt.XFStyle() # 初始化样式
font = xlwt.Font() # 为样式创建字体
font.name = 'Time New Roman'
font.bold = True
font.height = 15*10
style.font = font
#写入excel
workbook = xlwt.Workbook()
sheet1 = workbook.add_sheet(sheetname='sheet1')
text = ["用例目录","用例名称","需求ID","前置条件","用例步骤","预期结果","用例类型","用例状态",
"用例等级","创建人","标签属性","自动化","功能版本","用例来源","用例标签"]
for i in range(0,len(text)):
sheet1.write(0,i,text[i],style)
workbook.save('C:\\Users\\lyndee\\Desktop\\demo.xls')