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)
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
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
How to change the name of exported file from cda-export to custom name
ReplyDeleteHow do you change the format of columns in this .xls file? Any leads would be appreciated!!
ReplyDeleteSir, 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
ReplyDeletehello i need export only one page. Please?????
ReplyDelete