擅长:python、mysql、java
<p>未定义<code>passorfail</code>。另外,您试图设置错误的单元格背景颜色。在</p>
<p>以下是包含修复的代码(<code>passorfail</code>从<code>raw_input()</code>读取):</p>
<pre><code>import xlwt
with open('input.txt', 'r') as f:
passorfail = f.read()
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('Status')
style = xlwt.easyxf()
pattern = xlwt.Pattern()
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
if passorfail in ['pass', 'Passed', 'passed']:
pattern.pattern_fore_colour = xlwt.Style.colour_map['green']
elif passorfail in ['fail', 'Failed', 'failed']:
pattern.pattern_fore_colour = xlwt.Style.colour_map['red']
style.pattern = pattern
worksheet.write_merge(6, 6, 3, 3, passorfail, style=style)
workbook.save('passfail2.xls')
print "Completed"
</code></pre>
<p>编辑:</p>
<p>以下是从测试结果字典生成报告的代码:</p>
^{pr2}$
<p>希望有帮助。在</p>