Exporting Data from ADF Table
In this post we shall look at how to export data from an ADF table.To export data from an ADF table we shall use an export collection action listener from the operations component panel of ADF Faces.
General steps which i followed to export data from ADF Table declaratively.
- Inside a Layout container had a panel collection component
- Under this layout container have a panel collection component used
- Inside the panel collection dropped an read only ADF table
- Now we can either use the toolbar facet or menu facet of panel collection component
- In the current example have used toolbar facet have tried it with menu facet also the steps are the same.
- Toolbar facet of panel collection drop a toolbar and drop a button into the toolbar, give the button an appropriate text
i) ExportedId - ID of the component to be exported
ii) type - export type. The only currently supported value is 'excelHTML'
Other optional parameters are
iii) filename - file name for the exported content
iv) title - the title of the worksheet of the exported content
v) exportedRows - rows to include in the exported content
specific reason to use panel collection is to wrap my collection component which is the table as it provides toolbar and menu facets
Only the following can be exported:
Value of value holder components (such as input and output components).
Value of selectItem components used in selelctOneChoice and selectOneListbox components (the value of selectItem components in other selection components are not exported).
Value of the text attribute of a command component.
Value of the shortDesc attribute on image and icon components.
Following is the sample code snippet of my demo app.
<af:panelStretchLayout id="psl1">
<f:facet name="center">
<af:panelCollection id="pc1">
<f:facet name="menus"/>
<f:facet name="toolbar">
<af:toolbar id="t1">
<af:commandToolbarButton text="ExporttoExcel"
id="ctb1">
<af:exportCollectionActionListener type="excelHTML"
exportedId="datatoexport"
filename="Employee"
title="EmployeeExport"/>
</af:commandToolbarButton>
</af:toolbar>
</f:facet>
<f:facet name="statusbar"/>
<af:table value="#{bindings.ExportEmp.collectionModel}" var="row"
rows="#{bindings.ExportEmp.rangeSize}"
emptyText="#{bindings.ExportEmp.viewable ? 'No data to display.' : 'Access Denied.'}"
fetchSize="#{bindings.ExportEmp.rangeSize}"
rowBandingInterval="0"
selectionListener="#{bindings.ExportEmp.collectionModel.makeCurrent}"
rowSelection="multiple" id="datatoexport">
This is how the application looks when it is run
Once you click the export excel button a dialog appears on whether to save the data
Saved excel file worksheet title has the title as given in the export collection action listener title property
Uploaded is the sample app here
References:
