Steps:
1.Create ADF application and project.
2.Create VO and Include in AM
3.Create Page
4.Drag and drop VO from Data Controls to Page. Select object type as Table. Change table id to 'myTable'
5.Create ADF button and name it as 'Export to Excel'
6.Add ExportCollectionActionListener to Button and provide following properties.
exportedId="myTable" (myTable is id of af:table)
type="excelHTML"
filename="MyTable.xls"
title="MyTable"
7.Your page looks like this.
8.Run page and test it.
Source: http://adfreusablecode.blogspot.in/2012/07/export-to-excel-with-styles.html
1.Create ADF application and project.
2.Create VO and Include in AM
3.Create Page
4.Drag and drop VO from Data Controls to Page. Select object type as Table. Change table id to 'myTable'
5.Create ADF button and name it as 'Export to Excel'
6.Add ExportCollectionActionListener to Button and provide following properties.
exportedId="myTable" (myTable is id of af:table
type="excelHTML"
filename="MyTable.xls"
title="MyTable"
7.Your page looks like this.
8.Run page and test it.
Source: http://adfreusablecode.blogspot.in/2012/07/export-to-excel-with-styles.html
