利用python的xlsxwriter模块处理
1、pip install xlsxwriter安装xlsxwriter模块
2、举例
#encoding=utf-8
import time #导入time
import xlsxwriter #导入xlsxwriter
workbook = xlsxwriter.Workbook(tm+u'-发布模板.xlsx')
#生成20170720-发布模块.xlsx文件
worksheet = workbook.add_worksheet('Sheet0')
#创建Sheet0
bold_format = workbook.add_format({'bold':True})
#粗体格式
data_format = workbook.add_format({'num_format':'#,##'})
#数字格式0.00
date_format =workbook.add_format({'num_format':'yyyy-mm'})
#日期格式2017-07
#写第一行标题
worksheet.write('A1', u'盟友人员编号')
worksheet.write('B1', u'月份')
worksheet.write('C1', u'云闪付交易金额')
worksheet.write('D1', u'云闪付可分润金额')
worksheet.write('E1', u'拓展奖交易金额')
worksheet.write('F1', u'拓展奖可分润金额')
worksheet.write('G1', u'推广奖交易金额')
worksheet.write('H1', u'推广奖可分润金额')
worksheet.write('I1', u'园丁奖交易金额')
worksheet.write('J1', u'园丁奖可分润金额')
worksheet.write('K1', u'导师奖交易金额')
worksheet.write('L1', u'导师奖可分润金额')
#循环写10000行数据
for i in range(2,10001):
#print "A"+str(i)
num=random.randint(1,12)
worksheet.write("A"+str(i),"S000000000000000122"+str(i))
worksheet.write('B'+str(i), '2017-'+str(num),date_format)
worksheet.write('C'+str(i), '100.10',data_format)
worksheet.write('D'+str(i), '100.00',data_format)
worksheet.write('E'+str(i), '200.00',data_format)
worksheet.write('F'+str(i), '10.05',data_format)
worksheet.write('G'+str(i), '300.12',data_format)
worksheet.write('H'+str(i), '50.09',data_format)
worksheet.write('I'+str(i), '12345.10',data_format)
worksheet.write('J'+str(i), '5.55',data_format)
worksheet.write('K'+str(i), '876.10',data_format)
worksheet.write('L'+str(i), '100.00',data_format)
#关闭sheet
workbook.close()