Excel Report, xlsx report - Report Design in Excel

by
Odoo

106.31

v 15.0 Third Party 23
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 1705
Technical Name report_excel_template
Versions 13.0 15.0 12.0 14.0 16.0 17.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 1705
Technical Name report_excel_template
Versions 13.0 15.0 12.0 14.0 16.0 17.0

Report Excel Template

Simple & Effective

Design print templates using excel

The purpose of the introduction of the "Report Excel Template" module allows system administrators to create excel export templates and excel reports in the simplest way, system administrators do not need to know odoo programming can still create. Excel export templates, excel reports according to your wishes.

DEMO

I .Print

To make it easier to understand, I will take a specific Create menu: Remember to clickexample, export the purchase order to excel according to the form:

Step 1: Create an excel template

Step 2: Configure

Note: To configure, turn on debug mode.

1. Go to menu: Setup/Technology/Report/Excel Report

2. Create a new excel report

Don't forget to upload the template cell file.

- Meaning of each column

3. Go to create a printed menu in the purchase order:

Create menu: Remember to click "Add print button in menu".

That's it :)

Let's do a test print :)

And results :)

It's really simple, isn't it?  Next do the report

II. Excel export report

For example: Sales report

1.     Create a sample file:

2.     Create a new Excel report

It's done .

Let's see the results 

It's done  isn't it simple?

Supports

Free 24/7

For any supports or questions, please contact me via:

dev.odoo.vn@gmail.com

Thank you!

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
There are no ratings yet!
Its done!
by
Joaquin Jerez
on 2/16/24, 7:13 AM Confirmed Purchase

The color I can select in Excel.

Thank


Re: Its done!
by
Dev Odoo
on 2/16/24, 10:13 PM Author

Yes


Now is working.
by
Joaquin Jerez
on 2/16/24, 7:03 AM Confirmed Purchase

One cuestion:
How I can include color in this column?

#{align=right;style=text}

Thank


Re: Now is working.
by
Dev Odoo
on 2/16/24, 10:15 PM Author

Open the styles.py file and it will be there


error when try print. Thank
by
Joaquin Jerez
on 2/16/24, 6:44 AM Confirmed Purchase

RPC_ERROR

Odoo Server Error

Traceback (most recent call last):

  File "/odoo/custom/addons/hosting_requerido/report_excel_template/controllers/controllers.py", line 88, in report_download

    report_name = safe_eval(report.print_report_name, {'object': obj, 'time': time})

  File "/odoo/odoo-server/odoo/tools/safe_eval.py", line 319, in safe_eval

    check_values(globals_dict)

  File "/odoo/odoo-server/odoo/tools/safe_eval.py", line 373, in check_values

    raise TypeError(f"""Module {v} can not be used in evaluation contexts

TypeError: Module can not be used in evaluation contexts


Prefer providing only the items necessary for your intended use.


If a "module" is necessary for backwards compatibility, use

`odoo.tools.safe_eval.wrap_module` to generate a wrapper recursively

whitelisting allowed attributes.


Pre-wrapped modules are provided as attributes of `odoo.tools.safe_eval`.



Re: error when try print. Thank
by
Dev Odoo
on 2/16/24, 10:17 PM Author

What version of odoo are you running?

You can contact me via skype: dev.odoo.vn@gmail.com for direct support


One cuestion before buy, Is working in all version Excel?
by
Joaquin Jerez
on 2/14/24, 5:10 AM Confirmed Purchase
Re: One cuestion before buy, Is working in all version Excel?
by
Dev Odoo
on 2/16/24, 10:18 PM Author

Unlimited excel versions