Dashboard > Pentaho Reporting > Home > Task136372TableExportPOI
Task136372TableExportPOI
Added by Thomas Morgner, last edited by Thomas Morgner on Feb 19, 2007  (view change)
Labels: 
(None)


Create an Excel-Export for LibLayout

Task Description

Aim of this task is to write a renderer for the Excel-output. The Excel-workbook is generated using the POI library and the LibLayout/CSS3 style properties must be mapped properly into the excel-specific settings. As Excel only has limited number of formats and slots available, styling is more than just a simple mapping.

Requirements

This task depends on the base table-export code.

Solution Approach

As first solution, take a look at the sourcecode of the classic engine and implement the same. POI does not support rich-text cell contents, so we have to transform the cell contents into plain text. For a perfect layout, the rendering step has no 'know' that rich-text is not supported and has to take this into account when computing the layout. The interesting question would be: How do we compute the final style for the cell if multiple text styles can be applied within the same cell?

Site powered by a free Open Source Project / Non-profit License (more) of Confluence - the Enterprise wiki.
Learn more or evaluate Confluence for your organisation.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.2 Build:#807 May 20, 2007) - Bug/feature request - Contact Administrators