Community mailing list archives

community@mail.odoo.com

RE: [9.0] Export Invoice to MS Excel

by
Luc De Meyer
- 11/15/2015 03:50:39

The “account_invoice_line_xls” module (based upon report_xls) allows (via an inherited module)

-          To customize header & footer (hence you can add company logo)

-          To customize the XLS template (adding fields, changing styles, …)

-          Adding charts will require some programming

 

I haven’t tested the module on v9 yet, but I will happily review your work if you port it (or even better port it and submit the port as an OCA PR against the ‘account-financial-reporting’ repo.

 

 

www.noviat.com

Rusatiralaan 1, 1083 Brussel

+32 2 808 86 38

 

<img border=0 width=96 height=33 id="Picture_x0020_1" src="cid:image001.jpg@01D11F8A.A42E4A20" alt="cid:image002.jpg@01CE271A.FF53FB90">

 

From: Mohamed Magdy [mailto:moh.magdy40@gmail.com]
Sent: zondag 15 november 2015 5:58
To: Community <community@mail.odoo.com>
Subject: Re: [9.0] Export Invoice to MS Excel

 

It sounds great but can I ask if it can help me with these needs:

  • I need to format the invoice and use styles, tables for X2many fields and so on.

  • I need to add 'Charts' based on the data in the invoices, if possible.

  • I need to add the company information including the logo.

These are the requirements I have, the most important are the 1st and 2nd points.

Thank you again.

 

On Sun, Nov 15, 2015 at 6:52 AM senthilnathan g <bornspy@gmail.com> wrote:

Dear Magdy,

 

I use that same module in version 8 and 9 (ported) works fine for me.

 

Using the report_xls module, i developed a custom xls report with 15 sheets of xls file  contains custom tables & style.

 

I created a custom module to download xml format (report_xml) using report_xls as reference.

 

So you can create your own module to create xls with report_xls as base dependency to download XLS file same like PDF download(using wizard).

 

Regards

Senthilnathan G

 

On Sun, Nov 15, 2015 at 12:34 PM, Mohamed Magdy <moh.magdy40@gmail.com> wrote:

Dear Senthilnathan,

I really appreciate your kind support.

These modules will not work for Odoo 9.0, and it is not enough for me. Let me explain more:

  • I need to format the invoice and use styles, tables for X2many fields and so on.

  • I need to add 'Charts' based on the data in the invoices, if possible.

  • I need to add the company information including the logo.

These needs are not covered in the existing modules.

 

On Sun, Nov 15, 2015 at 6:17 AM senthilnathan g <bornspy@gmail.com> wrote:

Magdy,

 

You can use export option and create a export field list to download the format with fields.

 

Otherwise you can use report_xls module from https://apps.openerp.com/apps/7.0/report_xls/ to create your own custom format of xls.

 

You can use the same reference to create other report file format such as xml,csv


 Regards

Senthilnathan G

 

On Sun, Nov 15, 2015 at 12:02 PM, Mohamed Magdy <moh.magdy40@gmail.com> wrote:

Dear Experts,

I was looking for a module to export the invoices to MS Excel so that the user can use it after exporting it.

As you know, it is important for many users to have reports that exported in *.xlsx format rather than the PDF version.

I did not find any. So, should I write my own or someone will push it for the community?

Thanks in advance :)

--

Best Regards,

 

Mohamed Magdy

Odoo Technical Team Leader

_______________________________________________

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

--

Best Regards,

 

Mohamed Magdy

Odoo Technical Team Leader

_______________________________________________

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

--

Best Regards,

 

Mohamed Magdy

Odoo Technical Team Leader

Mob 1: +201114347478

Mob 2: +201095179215

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe