odoo 16 enterprise, export custom report xlsx format.

Question

I'd like to create a new report xlsx format. Maybe I can use odoo studio.
I only can see the report types are "Text, pdf, html".
Is it possible on enterprise version then can someone tell me how?
Thanks,

Savya Sachin · Accepted Answer

Hi,
AFAIK Odoo Studio doesn't directly support XLSX report creation.
You can create a custom excel format using the report_xlsx module on the enterprise.
Creating Excel Report Using Odoo [1]
Excel report [2]
Thanks

[1] https://bassaminfotech.com/how-to-create-excel-report-using-odoo/
[2] https://www.youtube.com/watch?v=6rVHBO-zmQE&t=744

Midhun Sankar P · Answer

Hi Sam,
You cannot  create a xlsx report using the studio. You need to customise it through code. Please refer to this blog : https://www.cybrosys.com/blog/how-to-generate-xlsx-report-using-controller-in-odoo-16 [1]
Another way you can do is using the export feature and select the necessary columns you want to see in the report and export it.

[1] https://www.cybrosys.com/blog/how-to-generate-xlsx-report-using-controller-in-odoo-16

Related Posts	Відповіді	Переглядів
Enterprise Source code enterprise studio	2 черв. 24	15531
Adding simple logic to a custom field in studio Вирішено enterprise studio odoo16features	3 січ. 24	3433
item line sales order odoo 16 enteprise enterprise studio odoo16features	3 лист. 23	2507
Save excel report to disk on server enterprise xlsx 12.04	0 січ. 23	2082
Toggle Studio icon not appearing in Navbar in odoo 13 enterprise studio Odoo13.0	1 трав. 22	4269

Це запитання позначене

Enjoying the discussion? Don't just read, join in!