In my example I am taking case to add this in Menu Item.
Following are steps to do that.
- Add Toolbar , Menu and Menu Item to your ADF Page.
- Give a meaningful name to your Menu Item.
- Add Table control.
- From "Component Palette" go to "Operation" and drag “Export Collection Action Listener” and drop it over your Menu Item.
- In the Popup “Insert Export Collection Action Listener” enter value for table you want to export in “ExportedId” and “Type” as shown below.
![](http://2.bp.blogspot.com/_7Ak4gihVK6k/SeSAahzxCgI/AAAAAAAAACs/d-NhktveH3M/s400/capture1.bmp)
- For “ExportedId” select the value of the table that you want to export as shown below. (In my example, I have 2 split frames and my table is in 2nd Split Frame).
![](http://2.bp.blogspot.com/_7Ak4gihVK6k/SeSBgqRFlEI/AAAAAAAAAC0/z50Y0RxYl3o/s400/capture3.bmp)
- For Type “Select excelHTML” from drop down list and you are all set to go.
![](http://4.bp.blogspot.com/_7Ak4gihVK6k/SeSBv5GeqtI/AAAAAAAAAC8/Hhpqrw7vMbI/s400/capture4.bmp)
- At Run time select your Menu and export data to excel.
Very good blog.All Instruction are very clear .
ReplyDeleteI am able to do all that.
Ni