OCA reporting engine fork for dev and update.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

84 lines
3.0 KiB

  1. <section class="oe_container">
  2. <div class="oe_row oe_spaced">
  3. <div class="oe_span12">
  4. <h2 class="oe_slogan">Excel report engine</h2>
  5. </div>
  6. <div class="oe_span6">
  7. <div class="oe_demo oe_picture oe_screenshot">
  8. <img src="open_receivables.png">
  9. </div>
  10. </div>
  11. <div class="oe_span6">
  12. <p class="oe_mt32">
  13. <br><br>This module adds Excel export capabilities to the standard odoo reporting engine.
  14. </p>
  15. </div>
  16. </div>
  17. </section>
  18. <section class="oe_spaced oe_container oe_dark">
  19. <div class="oe_row">
  20. <h2 class="oe_slogan">Report development</h2>
  21. <p class="oe_mt32">
  22. In order to create an Excel report you can
  23. <ul>
  24. <li>define a report of type 'xls'</li>
  25. <li>pass <code>{'xls_export': 1}</code> via the context to the report create method</li>
  26. </ul>
  27. </p>
  28. <p class="oe_mt32">
  29. The <code>report_xls</code> class contains a number of attributes and methods to facilitate the creation XLS reports in odoo.
  30. <ul>
  31. <li>
  32. cell types
  33. <br>Supported cell types : text, number, boolean, date.
  34. </li>
  35. </ul>
  36. <ul>
  37. <li>
  38. cell styles
  39. <br>The predefined cell style definitions result in a consistent look and feel of the odoo Excel reports.
  40. </li>
  41. </ul>
  42. <ul>
  43. <li>
  44. cell formulas
  45. <br>Cell formulas can be easily added with the help of the <code>rowcol_to_cell()</code> function which you can import from the <code>utils.py</code> module.
  46. </li>
  47. </ul>
  48. <ul>
  49. <li>
  50. Excel templates
  51. <br>It is possible to define Excel templates which can be adapted by 'inherited' modules.
  52. <br>Download the <b>account_move_line_report_xls</b> module from <a href="http://apps.odoo.com">http://apps.odoo.com</a> as example.
  53. </li>
  54. </ul>
  55. <ul>
  56. <li>
  57. XLS with multiple sheets
  58. <br>Download the <b>account_journal_report_xls</b> module from <a href="http://apps.odoo.com">http://apps.odoo.com</a> as example.
  59. </li>
  60. </ul>
  61. </p>
  62. </div>
  63. </section>
  64. <section class="oe_container">
  65. <div class="oe_row oe_spaced">
  66. <div class="oe_span12">
  67. <h2 class="oe_slogan">Development assistance</h2>
  68. </div>
  69. <div class="oe_span6">
  70. <br>
  71. <div class="oe_picture">
  72. <center><img src="help.png" height="150"></center>
  73. </div>
  74. </div>
  75. <div class="oe_span6">
  76. <p class="oe_mt32">
  77. <br><br>Contact <a href="mailto:info@noviat.com">info@noviat.com</a> for help with the development of Excel reports in odoo.
  78. </p>
  79. </div>
  80. </div>
  81. </section>