Use python to make a table frame template instance

来源:互联网 发布:苹果电脑关闭软件 编辑:程序博客网 时间:2024/05/26 17:45

Software environment

Eclipse version: Neon.2 Release(4.6.2)

Python version: Python 2.7


table frame template instance scripts as shown below:

from pyExcelerator import Workbook
import pyExcelerator

myfont=pyExcelerator.Font()
myfont.name=u'Arial'
myfont.height=230
mystyle=pyExcelerator.XFStyle()
mystyle.font=myfont

w=Workbook()
ws=w.add_sheet("Sheet1")
ws.col(0).width=7000
ws.col(1).width=3000
ws.col(2).width=3000
ws.col(3).width=3000
ws.col(4).width=3000
ws.col(5).width=3000
ws.col(6).width=3000
ws.col(7).width=3000
ws.col(8).width=3000

ws.write_merge(0,0,1,2,'Read',mystyle)
ws.write_merge(0,0,3,4,'Write',mystyle)
ws.write_merge(0,0,5,6,'Mixed',mystyle)

ws.write(1,1,u"rock",mystyle)
ws.write(1,2,u"inno",mystyle)

ws.write(1,3,u"rock",mystyle)
ws.write(1,4,u"inno",mystyle)

ws.write(1,5,u"rock",mystyle)
ws.write(1,6,u"inno",mystyle)

ws.write(2,0,u"read",mystyle)
ws.write(3,0,u"write",mystyle)
ws.write(4,0,u"other",mystyle)
ws.write(5,0,u"total",mystyle)
ws.write(6,0,u"transactions",mystyle)
ws.write(6,0,u"read/write requests",mystyle)
ws.write(7,0,u"other operations",mystyle)
ws.write(8,0,u"ignores errors",mystyle)
ws.write(9,0,u"reconnects",mystyle)
ws.write(10,0,u"General statistics",mystyle)
ws.write(11,0,u"event_execution",mystyle)
ws.write(12,0,u"min",mystyle)
ws.write(13,0,u"avg",mystyle)
ws.write(14,0,u"max",mystyle)
ws.write(15,0,u"approx. 95 percentile",mystyle)
ws.write(16,0,u"events(avg/stddev)",mystyle)
ws.write(17,0,u"execution(avg/stddev)",mystyle)

w.save('test.xls')


原创粉丝点击