#!/usr/bin/env python # -*- coding: utf-8 -*- from base import pub_param import os import xlrd,xlwt from openpyxl.reader.excel import load_workbook class excel: def __init__(self): pass def create_excel(self,header,lists): #新建工作簿 workbook=xlwt.Workbook(encoding='utf-8') #新建sheet sheets=workbook.add_sheet('test_data') # 添加表头数据,header为list格式的表头数据,例:[1,2,3] c=0 #column 纵向列 for x in header: # sheets.cell(row=0, column=c,value=x) sheets.write(0,c,x) c=c+1 # 添加列表数据,lists为是成员为list格式的元祖数据,例:([1,1,2],[1,2,3]) r=1 #row 横向列(0行为表头,从第一行开始写数据) for data in lists: c=0 # column 纵向列(从0开始写数据) for y in data: sheets.write(r,c,y) c=c+1 r = r + 1 # 保存 workbook.save('/Users/python/Tenancy/excels/' + pub_param.now_date + '.xls') # 文件保存在项目的excels目录内 # workbook.close() if __name__ == '__main__': header=['数字1','数字2','求和'] lists=([1,1,2],[2,2,4],[3,3,6]) sheets=excel().create_excel(header,lists)