#!/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)