def create_simple_xls(self, **kw):
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True
style0 = xlwt.XFStyle()
style0.font = font0
style1 = xlwt.XFStyle()
style1.num_format_str = 'D-MMM-YY'
wb = xlwt.Workbook(**kw)
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 'Test', style0)
ws.write(1, 0, datetime(2010, 12, 5), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
return wb, ws
python类Formula()的实例源码
def _create_skipped_reason_summary(self):
"""Create Skipped tests summary.
Describe amount of tests skipped since they were filtered by tags,
or noted as 'Already Passed' in the DB.
"""
for skip_reason in (self.TAGS_SKIP_MESSAGE,):
self._write_to_cell(self.row_number,
self.SUMMARY_RESULT_TYPE_COLUMN,
self.DEFAULT_CELL_STYLE,
self.SKIPPED_SUMMARY_PATTERN % skip_reason)
skip_count_formula = xlwt.Formula(self.FORMULA_PATTERN %
(self.TRACEBACK_COLUMN,
self.TRACEBACK_COLUMN,
self.row_number,
skip_reason))
self._write_to_cell(self.row_number,
self.SUMMARY_RESULT_COUNTER_COLUMN,
self.DEFAULT_CELL_STYLE,
skip_count_formula)
self.row_number += 1
def _create_result_summary(self):
"""Create result summary at the end of the Excel report."""
self.row_number += self.ROWS_TO_SKIP
for result_type in self.CONTENT_TO_STYLE:
self._write_to_cell(self.row_number,
self.SUMMARY_RESULT_TYPE_COLUMN,
self.CONTENT_TO_STYLE[result_type],
result_type)
result_type_count = xlwt.Formula(self.FORMULA_PATTERN %
(self.RESULT_COLUMN,
self.RESULT_COLUMN,
self.row_number,
result_type))
self._write_to_cell(self.row_number,
self.SUMMARY_RESULT_COUNTER_COLUMN,
self.DEFAULT_CELL_STYLE,
result_type_count)
self.row_number += 1
if result_type == self.SKIPPED:
self._create_skipped_reason_summary()
def create_simple_xls(self, **kw):
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True
style0 = xlwt.XFStyle()
style0.font = font0
style1 = xlwt.XFStyle()
style1.num_format_str = 'D-MMM-YY'
wb = xlwt.Workbook(**kw)
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 'Test', style0)
ws.write(1, 0, datetime(2010, 12, 5), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
return wb, ws
test_biff_records.py 文件源码
项目：InternationalizationScript-iOS
作者: alexfeng
项目源码
文件源码
阅读 21
收藏 0
点赞 0
评论 0
def test_intersheets_ref(self):
book = xlwt.Workbook()
sheet_a = book.add_sheet('A')
sheet_a.write(0, 0, 'A1')
sheet_a.write(0, 1, 'A2')
sheet_b = book.add_sheet('B')
sheet_b.write(0, 0, xlwt.Formula("'A'!$A$1&'A'!$A$2"))
out = BytesIO()
book.save(out)
def do_fill_workbook(self, workbook):
"""export to excel all articles tin stock"""
sheet = workbook.add_sheet(_(u"Stock"))
line = 0
columns = [
_(u'Id'), _(u'Name'), _(u'Category'), _(u'Purchase price'), _(u"Stock count"), _(u'Stock threshold'),
_(u'Value'),
]
for col, label in enumerate(columns):
self.write_cell(sheet, 0, col, label, style=self.get_header_style())
for line, item in enumerate(self.get_store_items()):
sheet.write(line + 1, 0, item.id)
sheet.write(line + 1, 1, item.name)
sheet.write(line + 1, 2, u'{0}'.format(item.category) if item.category else '')
sheet.write(line + 1, 3, item.purchase_price if item.purchase_price else 0)
sheet.write(line + 1, 4, '' if item.stock_count is None else item.stock_count)
sheet.write(line + 1, 5, '' if item.stock_count is None else item.stock_threshold)
sheet.write(line + 1, 6, xlwt.Formula('D{0}*E{0})'.format(line + 2)))
sheet.write(line + 3, 6, xlwt.Formula('SUM(G1:G{0})'.format(line + 2)))
test_biff_records.py 文件源码
项目：InternationalizationScript-iOS
作者: alexfeng
项目源码
文件源码
阅读 18
收藏 0
点赞 0
评论 0
def test_intersheets_ref(self):
book = xlwt.Workbook()
sheet_a = book.add_sheet('A')
sheet_a.write(0, 0, 'A1')
sheet_a.write(0, 1, 'A2')
sheet_b = book.add_sheet('B')
sheet_b.write(0, 0, xlwt.Formula("'A'!$A$1&'A'!$A$2"))
out = BytesIO()
book.save(out)
def external_review_payment(request):
checklists = Checklist.objects.filter(blueprint__slug='external_review').exclude(status__in=['new', 'dropped']).filter(
Q(billing_state=None)|Q(billing_state__isnull=False, billing_state__billed_at=None))
price = Price.objects.get_review_price()
if request.method == 'POST':
selected_for_payment = []
for checklist in checklists:
if request.POST.get('pay_%s' % checklist.pk, False):
selected_for_payment.append(checklist)
reviewers = User.objects.filter(pk__in=[c.user.pk for c in selected_for_payment]).distinct()
xls = SimpleXLS()
xls.write_row(0, (_('amt.'), _('reviewer'), _('EC-Nr.'), _('sum'), _('IBAN'), _('SWIFT-BIC'), _('Social Security Number')), header=True)
for i, reviewer in enumerate(reviewers):
checklists = reviewer.checklist_set.filter(pk__in=[c.pk for c in selected_for_payment])
xls.write_row(i + 1, [
len(checklists),
str(reviewer),
", ".join(c.submission.get_ec_number_display() for c in checklists),
len(checklists) * price.price,
reviewer.profile.iban,
reviewer.profile.swift_bic,
reviewer.profile.social_security_number,
])
r = len(reviewers) + 1
xls.write_row(r, [
xlwt.Formula('SUM(A2:A%s)' % r),
"",
"",
xlwt.Formula('SUM(D2:D%s)' % r),
])
xls_buf = BytesIO()
xls.save(xls_buf)
doc = Document.objects.create_from_buffer(xls_buf.getvalue(),
mimetype='application/vnd.ms-excel', doctype='checklist_payment')
for checklist in selected_for_payment:
ChecklistBillingState.objects.update_or_create(
checklist=checklist, defaults={'billed_at': doc.date})
payment = ChecklistPayment.objects.create(document=doc)
payment.checklists = selected_for_payment
return redirect('ecs.billing.views.view_checklist_payment', payment_pk=payment.pk)
return render(request, 'billing/external_review.html', {
'checklists': checklists,
'price': price,
})
write_excel.py 文件源码
项目：Automation-Framework-for-devices
作者: tok-gogogo
项目源码
文件源码
阅读 21
收藏 0
点赞 0
评论 0
def write_model_value(self,mod_name,loop,dstReport):
#print 'Fuction write_model_value'
row = self.start_module_row + self.mod_row_offset
keyword = None
for x in range(0,9):
Hylink_Flag = False
if x ==0:
keyword = self.dstRst_total_mod['DoneNum']
elif x ==1:
keyword = dstReport['ScriptName']
#keyword = '.\\'+dstReport['ScriptName'].split('\\')[-2] + '\\'+self.fill_txt(dstReport['ScriptName'])
Hylink_Flag = True
elif x ==2:
keyword = '.\\'+dstReport['ScriptRestName'].split('\\')[-2] + '\\'+self.fill_txt(dstReport['ScriptRestName'])
elif x ==3:
keyword = dstReport['ScriptRestName']
Hylink_Flag = True
elif x ==4:
keyword = self.get_log_file(dstReport['ScriptRestName'])
Hylink_Flag = True
elif x ==5:
keyword = dstReport['Result']
else:
keyword =''
if Hylink_Flag==True:
tmp_str_path ='\\\\'.join(keyword.split('\\'))
if x==3:
tmp_st2 = self.fill_txt(dstReport['ScriptRestName'])
try:
self.sheet.write_merge(row,row,x,x,xlwt.Formula("HYPERLINK" + '("'+tmp_str_path+'";"'+tmp_st2+'")'),self.style6)
except Exception ,e:
log_print(e)
elif x ==1:
tmp_st2 = self.fill_txt(dstReport['ScriptName'])
try:
self.sheet.write_merge(row,row,x,x,xlwt.Formula("HYPERLINK" + '("'+tmp_str_path+'";"'+tmp_st2+'")'),self.style11)
except Exception,e:
log_print(e)
else:
tmp_st2 = self.fill_txt(dstReport['ScriptRestName'])
try:
self.sheet.write_merge(row,row,x,x,xlwt.Formula("HYPERLINK" + '("'+tmp_str_path+'";"'+tmp_st2+'")'),self.style7)
except Exception ,e:
log_print(e)
else:
self.sheet.write(row,x,keyword,self.style1)
self.dstRst_total_mod['DoneNum'] = str(self.mod_row_offset)
try:
dstReport['Result'].find(KEY_RESULT_OK)
except Exception,e:
log_print(e)
if (dstReport['Result'].find(KEY_RESULT_OK))>-1:
self.dstRst_total_mod['OKNum'] = str(string.atoi(self.dstRst_total_mod['OKNum']) + 1)
else:
self.dstRst_total_mod['NGNum'] = str(string.atoi(self.dstRst_total_mod['NGNum']) + 1)
self.write_model_done(row-self.mod_row_offset)
