def _get_header_styles(self):
s1 = XFStyle()
al = Alignment()
al.horz = Alignment.HORZ_CENTER
s1.alignment = al
s2 = XFStyle()
borders = Borders()
borders.bottom = 2
s2.borders = borders
return s1, s2
#实际在这里开始for，循环的取excel中的动态值
if sheet_read_only.cell_value(6, 2) == 'form':
content_type = 'application/x-www-form-urlencoded'
else:
content_type = 'application/json'
#把取出的值进行转字典
params = eval(sheet_read_only.cell_value(6, 3))
response = request(request_type, url, params=params)
rs = eval(response.text) # 仅仅获得所有的返回值
if response.status_code == sheet_read_only.cell_value(
6, 4) and rs['error_code'] == sheet_read_only.cell_value(6, 5):
original_wb = open_workbook(r'd:\聚合数据.xls', formatting_info=True)
new_wb = copy(original_wb)
sheet = new_wb.get_sheet(0)
border = Borders()
border.left = border.THIN
border.right = border.THIN
border.top = border.THIN
border.bottom = border.THIN
style = XFStyle()
style.borders = border
sheet.write(6, 6, '通过', style)
new_wb.save(r'd:\聚合数据测试报告.xls')
border.left = border.THIN
border.right = border.THIN
border.top = border.THIN
border.bottom = border.THIN
font = Font()
font.bold = True
alignment = Alignment()
alignment.horz = alignment.HORZ_CENTER
pattern = Pattern()
pattern.pattern = pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 0x35
title_style.borders = border
title_style.font = font
title_style.alignment = alignment
title_style.pattern = pattern
for i in range(len(title)):
sheet.write(4, i + 4, title[i], title_style)
content = [[1, 'SMITH', '测试', '蔡昶', '2020-10-10'],
[2, '凤姐', '开发', '蔡昶', '2020-10-11']]
content_style = XFStyle()
border = Borders()
border.left = border.THIN
border.right = border.THIN
border.top = border.THIN
from xlwt.Style import XFStyle
wb = open_workbook(r'd:\emp.xls',formatting_info=True)
sheet = wb.sheet_by_name('手机号码归属地查询')
row_value = sheet.row_values(1,1)
print(row_value)
content_style = XFStyle()
border = Borders()
border.left = border.THIN
border.right = border.THIN
border.top = border.THIN
border.bottom = border.THIN
content_style.borders = border
url = row_value[1]
params = row_value[3]
response = request(method=row_value[2],url=url, params=params)
print(response.status_code)
print(response.text)
if response.status_code==row_value[5]:
#{"resultcode":"101","reason":"错误的请求KEY","result":null,"error_code":10001}写入对应的单元格
new_wb = copy(wb)
new_sheet = new_wb.get_sheet(5)
new_sheet.write(1,7,response.text,content_style)
if response.text==row_value[4]:
new_sheet.write(1,8,'通过'.content_style)
else:
new_sheet.write(1,8,'不通过',content_style)
def add_ideogram_table(self, analyses,
widths=None,
# configure_table=True,
add_title=False, add_header=False, tablenum=1, **kw):
sh = self._wb.add_sheet(analyses[0].labnumber)
# 'sheet{:02n}'.format(self._sheet_count))
self._sheet_count += 1
cols = ['Status', 'N', 'Power', 'Moles_40Ar',
'Ar40', 'Ar40Er',
'Ar39', 'Ar39Er',
'Ar38', 'Ar38Er',
'Ar37', 'Ar37Er',
'Ar36', 'Ar36Er',
'Blank',
'Ar40', 'Ar40Er',
'Ar39', 'Ar39Er',
'Ar38', 'Ar38Er',
'Ar37', 'Ar37Er',
'Ar36', 'Ar36Er'
]
# write header row
hrow = 0
borders = Borders()
borders.bottom = 2
style = XFStyle()
style.borders = borders
for i, ci in enumerate(cols):
sh.write(hrow, i, ci, style=style)
numstyle = XFStyle()
numstyle.num_format_str = '0.00'
from operator import attrgetter
def getnominal_value(attr):
def get(x):
v = getattr(x, attr)
return float(v.nominal_value)
return get
def getstd_dev(attr):
def get(x):
v = getattr(x, attr)
return float(v.std_dev)
return get
def getfloat(attr):
def get(x):
v = getattr(x, attr)
return float(v)
return get
def null_value():
return lambda x: ''
attrs = [(attrgetter('step'),),
(getfloat('extract_value'),),
(null_value(),),
(getnominal_value('Ar40'),),
(getstd_dev('Ar40'),),
(getnominal_value('Ar39'),),
(getstd_dev('Ar39'),),
(getnominal_value('Ar38'),),
(getstd_dev('Ar38'),),
(getnominal_value('Ar37'),),
(getstd_dev('Ar37'),),
(getnominal_value('Ar36'),),
(getstd_dev('Ar36'),),
(null_value(),),
(getnominal_value('Ar40_blank'),),
(getstd_dev('Ar40_blank'),),
(getnominal_value('Ar39_blank'),),
(getstd_dev('Ar39_blank'),),
(getnominal_value('Ar38_blank'),),
(getstd_dev('Ar38_blank'),),
(getnominal_value('Ar37_blank'),),
(getstd_dev('Ar37_blank'),),
(getnominal_value('Ar36_blank'),),
(getstd_dev('Ar36_blank'),),
]
for i, ai in enumerate(analyses):
for j, arg in enumerate(attrs):
if len(arg) == 2:
func, style = arg
else:
func, style = arg[0], Style.default_style
sh.write(i + hrow + 1, 1 + j, func(ai),
style
)
border.left = border.THIN
border.right = border.THIN
border.top = border.THIN
border.bottom = border.THIN
font = Font()
font.blod = True
alignment = Alignment()
alignment.horz = alignment.HORZ_CENTER
pattern = Pattern()
pattern.pattern = pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 0x35
title_style.borders = border
title_style.font = font
title_style.alignment = alignment
title_style.pattern = pattern
for i in range(len(title)):
sheet.write(4, 4 + i, title[i], title_style)
content = [[7369, 'SMITH', 'CLERK', 7902, '12/17/1980'],
[7499, 'ALLEN', 'SALESMAN', 7698, '2/20/1981'],
[7521, 'WARD', 'SALESMAN', 7698, '2/22/1981'],
[7566, 'JONES', 'MANAGER', 7839, '4/2/1981'],
[7654, 'MARTIN', 'SALESMAN', 7698, '9/28/1981']]
content_style = XFStyle()
# border=Borders()
# border.left=border.THIN
# -*-coding:UTF-8 -*- from xlrd import open_workbook from xlutils.copy import copy from xlwt.Formatting import Borders from xlwt.Style import XFStyle yuanshi_excel=open_workbook(r'd:\自动化测试.xls',formatting_info=True) new_excel=copy(yuanshi_excel) sheet=new_excel.get_sheet(0) new_content=XFStyle() border=Borders() border.left=border.THIN border.right=border.THIN border.top=border.THIN border.bottom=border.THIN new_content.borders=border sheet.write(3,5,5,new_content) sheet.write(3,8,'mingyue',new_content) new_excel.save(r'd:\新表副本.xls')
