Hi Friends,
This blog explains about export you data into excel in ADF .Here in this example i am taking the one of the HR Schema Object Employees and see the how i am implementing this
step by step implementation:
1.Firstly we have to Create EO,VO,AM to the Employees Table and then the Data controls are appeared then drag the Employees vo into the Run page as a Readonly Table. and create the Button inside the table as show in the below Figure.
2. rightclick on the button and adf faces select "Export Collection Action Listener"give
ExportId:Which is the data you are going to export by clicking at the end arrow and give table id
Type :excelHtml bydefault,
Export Rows :no of rows you are going to export.
File Name:File name of the Excel sheet
Title:Title of the excel sheet
Finally the Data in the Employees Table is downloaded into a Excel Sheet
.
ADF internally used the Apche Poy Api for this Exporting data.
This blog explains about export you data into excel in ADF .Here in this example i am taking the one of the HR Schema Object Employees and see the how i am implementing this
step by step implementation:
1.Firstly we have to Create EO,VO,AM to the Employees Table and then the Data controls are appeared then drag the Employees vo into the Run page as a Readonly Table. and create the Button inside the table as show in the below Figure.
2. rightclick on the button and adf faces select "Export Collection Action Listener"give
ExportId:Which is the data you are going to export by clicking at the end arrow and give table id
Type :excelHtml bydefault,
Export Rows :no of rows you are going to export.
File Name:File name of the Excel sheet
Title:Title of the excel sheet
After Running the page
Finally the Data in the Employees Table is downloaded into a Excel Sheet
.
ADF internally used the Apche Poy Api for this Exporting data.
No comments:
Post a Comment