XLS Reporting in OpenERP

Update:

I have added my code which you can find here,

http://www.4shared.com/archive/XbokLlzO/reporting_latesttar.html

Extract it and read the help.txt file for further info. Good Luck !

What is it ?
I was looking for a native XLS report from OpenERP, which I could not find out. Instead of writing a new extension,

I thought of extending the existing Report engine. I completed the basic version of it.

How to get XLS report ?
You can go to Administration -> Low Level Objects -> Actions -> Report XML and choose a report, then change its type to XLS.

Now try accessing the report as you would do normally. It will through you XLS report.

This extension may not be stable yet, but can be used in development version.

Features:

  • No need to write new reports, It will just work with existing RML reports.
  • It can handle maximum of two levels of nested table in RML.
  • No external dependency except python-xlwt module.

How it Works ?

The new modified code adds a new type called xls and additional functions. When a report is invoked and the type is XLS, it will invoke rml2xls module, which will take care of converting the rml to xls and emit it. The rml2xls, depends on rml2html. The output html generated by rml2html is passed to a custom HTML parser. The HTML parser parses the necessary tags and writes into XLS file.

Where to Download ?

Once testing from our side gets over, I will share it with you.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: