Skip to main content
 首页 » 编程设计

python之Odoo 10 生成 xlsx 报告时出错

2024年12月31日8xing901022

我想在 xlsx 中导出自定义报告。我尝试了下面的代码,但是当我按下按钮导出时,出现错误 AccessDenied: Access denied。

odoo.addons.web.controllers.main: An exception occured during an http request 
Traceback (most recent call last): 
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\addons\web\controllers\main.py", line 72, in wrap 
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\addons\web\controllers\main.py", line 1480, in index 
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\http.py", line 118, in dispatch_rpc 
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\service\report.py", line 32, in dispatch 
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\service\security.py", line 13, in check 
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\addons\base\res\res_users.py", line 507, in check 
AccessDenied: Access denied 

报告 XML:

<report  
    id="action_report_excel" 
    model="account.invoice" 
    string="Export to XLSX" 
    report_type="xlsx" 
    name="module_name.report_name.xlsx" 
    file="module_name.report_name.xlsx" 
    attachment_use="False" 
/> 

Python 代码:

from report_xlsx.report.report_xlsx import ReportXlsx 
 
class CustomReportXlsx(ReportXlsx): 
 
    def generate_xlsx_report(self, workbook, data, objs): 
        for obj in objs: 
            report_name = obj.name 
            # One sheet by partner 
            sheet = workbook.add_worksheet(report_name[:31]) 
            bold = workbook.add_format({'bold': True}) 
            sheet.write(0, 0, obj.name, bold) 
 
CustomReportXlsx('report.module_name.report_name.xlsx', 'account.invoice') 

Python 向导:

def check_report(self): 
    data = {} 
    return self.env['report'].sudo().get_action(self, 'module_name.report_name.xlsx', data=data) 

请帮帮我

请您参考如下方法:

为模型 account.invoice 添加适当的访问权限。您当前的用户无权从account.invoice 模型

读取/写入数据