输出一个名片格式的Excel表:
先安装odoo15的report_xlsx插件,复制文件夹粘贴到同级目录或者系统addons都行。
下载地址如下:网盘里存的也是这个:(打不开的可以直接下载网盘那个,链接在下边)
Base report xlsx | Odoo Apps Store
链接:https://pan.baidu.com/s/1p6rmmCWzgRyV4GcIJF6YTQ
提取码:ybpt
在控制台引入这两个包
模块安装完成后: 设置-->技术-->报告-->随便点开一个进入编辑模式(XLSX)【安装成功】
在report.xml中加入:report card Excel
代码如下:
<?xml version="1.0" encoding="UTF-8" ?>
<odoo>
<record id="report_mysale_demo" model="ir.actions.report">
<field name="name">report demo</field>
<field name="model">mysale.mysale</field>
<field name="report_type">qweb-pdf</field>
<field name="report_name">mysale.report_mysale_demo</field>
<field name="report_file">mysale.report_mysale_demo</field>
<field name="binding_model_id" ref="model_mysale_mysale"/>
<field name="binding_type">report</field>
</record>
<record id="report_mysale_card" model="ir.actions.report">
<field name="name">report card</field>
<field name="model">mysale.mysale</field>
<field name="report_type">qweb-pdf</field>
<field name="report_name">mysale.report_mysale_demo</field>
<field name="report_file">mysale.report_mysale_demo</field>
<field name="binding_model_id" ref="model_mysale_mysale"/>
<field name="binding_type">report</field>
</record>
<record id="report_mysale_card_xlsx" model="ir.actions.report">
<field name="name">report card Excel</field>
<field name="model">mysale.mysale</field>
<field name="report_type">xlsx</field>
<field name="report_name">mysale.report_mysale_demo_xlsx</field>
<field name="report_file">mysale.report_mysale_demo_xlsx</field>
<field name="binding_model_id" ref="model_mysale_mysale"/>
<field name="binding_type">report</field>
</record>
</odoo>
要添加模型文件 继承 report_xlsx中的 report.report_xlsx.abstract
代码如下:
# -*- coding: utf-8 -*-
import base64
import io
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
row = 1
col = 2
# One sheet by partner
sheet = workbook.add_worksheet(report_name[:31]) # 数组从0-31
bold = workbook.add_format({'bold': True})
format_1 = workbook.add_format({'bold': True, 'align': 'center', 'bg_color': 'yellow'})
sheet.set_column('B:B', 20) # 拉长B列
sheet.merge_range(row, col, row, col + 1, 'ID Card', format_1)
row = row + 1
if obj.image:
image = io.BytesIO(base64.b64decode(obj.image))
sheet.insert_image(row, col, "image png", {'image_data': image, 'x_scale': 0.1, 'y_scale': 0.1})
row = row + 6
sheet.write(row, col, 'Name', bold)
sheet.write(row, col + 1, obj.name)
sheet.write(row + 1, col, 'Age', bold)
sheet.write(row + 1, col + 1, obj.age)
sheet.write(row + 2, col, 'serial_number', bold)
sheet.write(row + 2, col + 1, obj.serial_number)
代码的解释图如下:(我的字段为Name,Age,serial_number)
要在report文件中添加init文件:
在总的init文件中导入report
重启升级打印即可,还有很多知识点需要学习,明天再搞,以及上一节的导出PDF都有很多细碎的知识点没有学习,明日再做总结。