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')
- Use python to make a table frame template instance
- c# how to make app use a specified configure file
- How to make a random selection from an SQL table
- Use Teradata arcmain to archive/restore a table
- use autotools to make project
- contextTypes was defined as an instance property on MyButton. Use a static property to define contex
- How to Get the Frequency Table of a Categorical Variable as a Data Frame in R
- Use FFMPEG and SDL to show a frame of YUV (4:2:0)
- An AnnotationConfiguration instance is required to use
- An AnnotationConfiguration instance is required to use
- An AnnotationConfiguration instance is required to use
- How to use partition table
- ABI detection failed.make sure to use a matching tool chain when building
- How to use jquery template js
- some problem use html5 to make game
- use python to sendmail
- Use Python to plot
- use python to sendmail
- bzoj P1036 [ZJOI2008]树的统计Count
- 【C语言】编写模拟人员信息系统(结构体,文件)
- redis常用数据类型总结
- 双FIFO图像边缘提取
- ios中导航控制器的使用
- Use python to make a table frame template instance
- 【C语言】测试不同类型的指针的算术运算
- [第六季]1.Javascript概述和一个简单案例.
- C之可爱的疏漏
- 【HDU 1015】Safacraker(DFS)
- 【C语言】两条线段里选出比较长的(结构体)
- python与模块安装问题解决
- 尾部的零
- CentOS 6下Python处理utf-8的坑