Search 800 + Posts

May 1, 2010

How to export ADF table data into excel Sheet.

Oracle ADF provides lot of utilities and controls. Among them is how to export data from ADF table to Excel Sheet.
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.

  • 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).

  • For Type “Select excelHTML” from drop down list and you are all set to go.

  • At Run time select your Menu and export data to excel.
For more details or demo , send me an email.

1 comment:

  1. Very good blog.All Instruction are very clear .
    I am able to do all that.