Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Monday, 23 December 2013

Exporting table component to Excel Or CSV - Button Component Example in Pentaho CDE

Hi Guys,
We can export the tabular display of data to excel or csv using Button component available in pentaho CDE.

Example:
1) Lay out section
Design your lay out as per your requirement.
For example find the image below.

2) Components Section 
 i) Select "Export Button" from the list of "Others"
ii) In the properties
Name : Component Name (ExportExcel)
Lable : Name that appear on your button (Eg : ExportExcel_
Component Name: your table component Name(Eg: tableData)
HtmlObject : the column name where you are placing this button (Eg :ExportExcel or Panel1)


3) Data sources section :
In this example taken foodmart database to display some data in the form of table component.
Browse for the database connections in this blog site.


4) Preview
* Click on "ExportExcel" button ... you will find the pop up asking you to save the exported file.


NOTE :
Currently(23rd dec 2013 is the post written date) "Export button supports " Excel , CSV formats but not pdf.
In future pentaho may provide the functionality to export.

Formats Tested :
Excel:
xls ->Worked
xlsx -> Not worked
csv -> Worked

Need to figure out the following
1) Exporting to multiple pages
2) Pagination
3) Bulk data exporting  to Excel




4 comments:

  1. How to change the name of exported file from cda-export to custom name

    ReplyDelete
  2. How do you change the format of columns in this .xls file? Any leads would be appreciated!!

    ReplyDelete
  3. Sir, I followed the same steps mentioned above. But when i try to click on the export button, nothing works. In logs i get this error: ERROR [pt.webdetails.cda.CdaUtils] pt.webdetails.cda.exporter.ExporterException: Kettle exception during xls query

    ReplyDelete
  4. hello i need export only one page. Please?????

    ReplyDelete