Community mailing list archives

community@mail.odoo.com

Re: [9.0] Export Invoice to MS Excel

by
senthil
- 11/15/2015 00:20:32
Magdy,

1.You can use xls workbook to creates worksheets and font styles &  colors also can be added.
2.You can add charts and any other data (using wizard).
3.Company Logo can be added but i didn't try.



 Regards
Senthilnathan G

On Sun, Nov 15, 2015 at 12:57 PM, Mohamed Magdy <moh.magdy40@gmail.com> wrote:
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

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