def writerow(self, row, sheet_name='sheet', border=False, pattern_n=0):
style = xlwt.XFStyle()
if border:
borders = xlwt.Borders()
borders.left = 1
borders.right = 1
borders.top = 1
borders.bottom = 1
borders.bottom_colour = 0x3A
style.borders = borders
if pattern_n:
pattern = xlwt.Pattern() # Create the Pattern
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
# May be: NO_PATTERN,SOLID_PATTERN, or 0x00 through 0x12
pattern.pattern_fore_colour = pattern_n
# May be: 8 through 63. 0 = Black, 1 = White, 2 = Red, 3 = Green, 4 = Blue,
# 5 = Yellow, 6 = Magenta, 7 = Cyan, 16 = Maroon, 17 = Dark Green, 18 = Dark Blue, 19 = Dark Yellow ,
# almost brown), 20 = Dark Magenta, 21 = Teal, 22 = Light Gray, 23
# = Dark Gray,
style.pattern = pattern # Add Pattern to Style
#sheet.write(0, 0, 'Firstname',style)
if sheet_name not in self.sheets:
# Create if does not exist
self.create_sheet(sheet_name)
if self.sheets[sheet_name]['rows'] == 0:
self.sheets[sheet_name]['header'] = row
if self.sheets[sheet_name]['rows'] >= 65534:
self.save()
# create new sheet to avoid being greater than 65535 lines
self.create_sheet(sheet_name)
if self.sheets[sheet_name]['header']:
self.writerow(self.sheets[sheet_name]['header'], sheet_name)
for ci, col in enumerate(row):
if border:
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows'], ci,
self.cell(col) if not isinstance(
col, xlwt.ExcelFormula.Formula) else col,
style)
else:
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows'], ci,
self.cell(col) if not isinstance(col, xlwt.ExcelFormula.Formula) else col)
#print self.sheets[sheet_name]['rows'],ci, self.cell(col) if type(col) != lib.xlwt.ExcelFormula.Formula else col
self.sheets[sheet_name]['rows'] += 1
def write_title(self, sheet_name='sheet', border=False, pattern_n=0):
style = xlwt.XFStyle()
if border:
borders = xlwt.Borders()
borders.left = 1
borders.right = 1
borders.top = 1
borders.bottom = 1
borders.bottom_colour = 0x3A
style.borders = borders
if pattern_n:
pattern = xlwt.Pattern() # Create the Pattern
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
# May be: NO_PATTERN,SOLID_PATTERN, or 0x00 through 0x12
pattern.pattern_fore_colour = pattern_n
# May be: 8 through 63. 0 = Black, 1 = White, 2 = Red, 3 = Green, 4 = Blue,
# 5 = Yellow, 6 = Magenta, 7 = Cyan, 16 = Maroon, 17 = Dark Green, 18 = Dark Blue, 19 = Dark Yellow ,
# almost brown), 20 = Dark Magenta, 21 = Teal, 22 = Light Gray, 23 = Dark Gray,
alignment = xlwt.Alignment() # Create Alignment
alignment.horz = xlwt.Alignment.HORZ_CENTER
# May be: HORZ_GENERAL,HORZ_LEFT, HORZ_CENTER, HORZ_RIGHT, HORZ_FILLED, HORZ_JUSTIFIED,HORZ_CENTER_ACROSS_SEL, HORZ_DISTRIBUTED
alignment.vert = xlwt.Alignment.VERT_CENTER
# May be: VERT_TOP,VERT_CENTER, VERT_BOTTOM, VERT_JUSTIFIED, VERT_DISTRIBUTED
style.alignment = alignment # Add Alignment to Style
style.pattern = pattern # Add Pattern to Style
#sheet.write(0, 0, 'Firstname',style)
if sheet_name not in self.sheets:
# Create if does not exist
self.create_sheet(sheet_name)
if self.sheets[sheet_name]['rows'] == 0:
self.sheets[sheet_name]['header'] = row
if self.sheets[sheet_name]['rows'] >= 65534:
self.save()
# create new sheet to avoid being greater than 65535 lines
self.create_sheet(sheet_name)
if self.sheets[sheet_name]['header']:
self.writerow(self.sheets[sheet_name]['header'], sheet_name)
if border:
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows']+1,\
0,\
0,\
u"序号",\
style)
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows']+1,\
1,\
1,\
u"摘要",\
style)
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows']+1,\
2,\
2,\
u"资源名称",\
style)
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows']+1,\
3,\
3,\
u"端口",\
style)
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows']+1,\
4,\
4,\
u"speed",\
style)
### 接收速率(Mbps)
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows'],\
5,\
7,\
u"接收速率(Mbps)",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
5,\
u"最大值",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
6,\
u"平均值",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
7,\
u"最小值",\
style)
### 接收利用率(%)
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows'],\
8,\
10,\
u"接收利用率(%)",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
8,\
u"最大值",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
9,\
u"平均值",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
10,\
u"最小值",\
style)
### 发送速率(Mbps)
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows'],\
11,\
13,\
u"发送速率(Mbps)",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
11,\
u"最大值",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
12,\
u"平均值",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
13,\
u"最小值",\
style)
### 发送利用率(%)
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows'],\
14,\
16,\
u"发送利用率(%)",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
14,\
u"最大值",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
15,\
u"平均值",\
style)
self.sheets[sheet_name]['sheet'].write(self.sheets[sheet_name]['rows']+1,\
16,\
u"最小值",\
style)
### 带宽利用率
self.sheets[sheet_name]['sheet'].write_merge(self.sheets[sheet_name]['rows'],\
self.sheets[sheet_name]['rows']+1,\
17,\
17,\
u"带宽利用率(%)",\
style)
#print self.sheets[sheet_name]['rows'],ci, self.cell(col) if type(col) != lib.xlwt.ExcelFormula.Formula else col
self.sheets[sheet_name]['rows'] += 2