I am following the procedure of generating xlsx , i have also downloaded and installed report_xlsx module but it is not working.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- 회계
- 재고 관리
- PoS
- Project
- MRP
신고된 질문입니다
3
답글
14496
화면
Yes I have followed every step mentioned above and there is no error while upgrading the module but when I click on generate xlsx report button on print dropdown then no action happens.
Hi,
Please see this tutorial explaining how to create excel report in odoo using the report_xlsx module from OCA: https://www.youtube.com/watch?v=cCyMy2kxxZs
Thanks
Are you followed below steps? Let me know post your report_xlsx odoo error.
https://apps.odoo.com/apps/modules/13.0/odoo_report_xlsx/
Installation
Make sure you have xlsxwriter Python module installed:
$ pip3 install xlsxwriter
For testing it is also necessary xlrd Python module installed:
$ pip3 install xlrd
Usage
An example of XLSX report for partners on a module called module_name:
A python class
from odoo import models
class PartnerXlsx(models.AbstractModel):
_name = 'report.module_name.report_name'
_inherit = 'report.odoo_report_xlsx.abstract'
def generate_xlsx_report(self, workbook, data, partners):
for obj in partners:
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)
To manipulate the workbook and sheet objects, refer to the documentation of xlsxwriter.
A report XML record
<report
id="partner_xlsx"
model="res.partner"
string="Print to XLSX"
report_type="xlsx"
name="module_name.report_name"
file="res_partner"
attachment_use="False"
/>
