Community mailing list archives

community@mail.odoo.com

RE: [9.0] Export Invoice to MS Excel

by
Luc De Meyer
- 11/21/2015 05:19:38

Report_xls documentation:

as far as I know, the only documentation is in the module __openerp__.py file.

 

It’s best to have a look at examples, e.g.

-          account_move_line_report_xls, account_journal_report_xls  in https://github.com/OCA/account-financial-reporting

-          account_invoice_line_xls in https://github.com/luc-demeyer/noviat-apps

 

Regards,

Luc

 

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@01D1244E.543CE120" alt="cid:image002.jpg@01CE271A.FF53FB90">

 

From: Hesham ELMAHDY [mailto:hesham.elmahdy@odootec.com]
Sent: vrijdag 20 november 2015 20:52
To: Community <community@mail.odoo.com>
Subject: Re: [9.0] Export Invoice to MS Excel

 

Gents,

 

Is there any video or guide on how to use the report_xls? 

 

On Mon, Nov 16, 2015 at 10:28 AM Gustavo Marino <gamarino@numaes.com> wrote:

Luke:

It was developed for v8.0, but I foresee no big problem in the porting to v9

It has a similar feature set of Aeroo Reports (once it can handle images), but with a very pragmatic approach (no libs, no install problems, just open standards file format handling).

As already said, it is work in progress, so any idea is welcomed.

Regards


Gustavo Adrian Marino

 

Mobile:  +54 911 5498 2515

Email: gamarino@numaes.com

Skype: gustavo.adrian.marino

 

<img border="0" width="213" height="94" src="cid:image001.jpg@01CC37F5.99B4CD20" alt="Descripción: Numa Logo V 1-0">

 

 

2015-11-15 14:22 GMT-03:00 Luke Branch <odoocommunitywidgets@gmail.com>:

Hi Gustavo,

 

This looks very interesting indeed. Can this handle roughly the same functionality as Aeroo Reports, and is it targeting the 9.0 branch?

 

One of the main things stopping me from creating a pilot project with 9.0 is the lack of a 9.0 branch for Aeroo Reports, or an alternative. If this can handle much of the same functionality I would be very interested in testing it out.

Sent from my iPhone


On 15 Nov 2015, at 11:22 PM, Gustavo Marino <gamarino@numaes.com> wrote:

Mohamed:

In this public github repo https://github.com/gamarino/numa_public.git you will find numa_opendoc_reports, a module to produce OpenDoc documents out of OpenDoc templates.

 

You can create a report, design a template using a syntax similar to the old RML reports and once this report is applied to the object it will create an editable OpenDoc file.

 

It can handle odt, ods and odp templates and outputs, son you can use it to generate something that can be converted to an excel file.

 

For sure it can handle static images, tables (in odp docs also), and the output documents are editable and thus the can be further improved to get the final result

 

It is still work in progress. It does not handle dynamic images yet, but if you want to add the feature, I'll be gratefull!!

 

It does not need any additional library in order to work. Everything is contained in the module itself

 

I'll appreciate your comments

Regards


Gustavo Adrian Marino

 

Mobile:  +54 911 5498 2515

Email: gamarino@numaes.com

Skype: gustavo.adrian.marino

 

<img border="0" width="213" height="94" src="cid:image001.jpg@01CC37F5.99B4CD20" alt="Descripción: Numa Logo V 1-0">

 

 

2015-11-15 1:57 GMT-03:00 Mohamed Magdy <moh.magdy40@gmail.com>:

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

 

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

<image001.jpg>

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

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

--

 

 

Regards,

 

Hesham ELMAHDY

Management & Software Technology Advisor

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