Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Can we use Excel Template for Reporting?

  1. #1
    Join Date
    Apr 2010

    Default Can we use Excel Template for Reporting?


    I am new to Pentaho. I am evaluating Pentaho BI suite.
    I have few queries related to Excel Reporting using Pentaho.
    - Can we use excel templates for Reporting?(Export to customized excel excel)
    - If so, in case of formula and dynamic ranges/sections in report how should we approach.
    Is there any libraries available so that we can customize and automate report processing with Pentaho?

    Thank you in advance,

  2. #2
    Join Date
    Mar 2008


    With the Reporting-Engine you can't use excel templates. The engine tries to recreate your report layout as close as possible in excel. From my experience this layout-oriented approach makes the excel-export not so usefull for people who want to work further with the data in excel. To have a "clean" table in excel you really need to take care in your report layout.
    For excel power-users a much better solution could be to export data with kettle. There you can also use sort of excel-templates (quite limited).
    Here is an idea about how this could work:



  3. #3
    Join Date
    Apr 2010


    Hi Mgie,
    Thanks for your inputs and the URL.
    So, I won't be able to use Pentaho Reporting using Excel Templates manually created which is having Macros,formulas and dynamic ranges and multiple sheets.

    How much customization can be done for excel using data export to Kettle? Can we set dynamic ranges and multiple sheets in excel based on data export to excel?

    Thanks Again,

  4. #4
    Join Date
    Mar 2003


    If you want to have a feature that is not yet there, file us a JIRA case.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.