sheet.write(0, 0, obj.name, bold) 坐标显示(0,0)
改成(1,1)坐标,再次运行:
from odoo import api, fields, models, _
class report_card_Excel(models.AbstractModel):
_name = 'report.mysale.report_mysale_demo_xlsx'
_inherit = 'report.report_xlsx.abstract'
def generate_xlsx_report(self, workbook, data, partners):
for obj in partners:
report_name = obj.name
sheet = workbook.add_worksheet(report_name[:31])
bold = workbook.add_format({"bold": True})
sheet.write(1, 1, obj.name, bold)
sheet.write(1, 1, obj.name, bold)中的bold属性为【字体加粗】,去掉后效果如下:
用循环来打印多个表的字段至一张Excel:多选然后打印:
代码:
from odoo import api, fields, models, _
class report_card_Excel(models.AbstractModel):
_name = 'report.mysale.report_mysale_demo_xlsx'
_inherit = 'report.report_xlsx.abstract'
def generate_xlsx_report(self, workbook, data, partners):
sheet = workbook.add_worksheet("测试打印多个字段")
bold = workbook.add_format({"bold": True})
row = 3
col = 3
for obj in partners:
row += 1
sheet.write(row, col, obj.name, bold)
给每一行字段添加一个标识&#