Recently browsing through Listener Tags in ADF I came across ExportCollectionActionListener. I was surprised to see how easy it is to export the collection of records to excel. If you are new to ExportCollectionActionListener, go on reading rest of article.
Drag and Drap the ExportCollectionActionListener to the Export Button or Menu. In the Insert dialog provide the value for ExportedId which should be pointing to table that needs to be exported.
Use the Edit from the action menu Of ExportedId property. Select excelHTML for Type.
Now select the Listener and go the properties and provide the file name and Title and that’s it. Here is the result:
