How To Generate Report in Xcel/Html Format in ADF 12C

Hi Guys, Today I'll give an idea related to Report.we have several ways to generate report in ADF .
we can integrate jasper report/BI report and normal excel and HTML format report.

Here I'll show you how can we generate normal excel format report.there are some steps which you need to follow and at the end you will able to save/open your report in the excel format.

S1. Create an Application and  project structure like below screen shot.

                                   

S2. Create Employee EO and VO and create one View criteria which will search on the basis of Emp        Name and Department Number.

                                                  

S3. Create a page ExportReportDemo.jsf and drag Emp VO in that page with table.

            

                                               

     

S4. Create a command button and inside that button drag <af:exportCollectionActionListener /> from        the component palate.

   <h:commandButton value="Export to Excel" id="cb1"

                                 binding="#{backingBeanScope.backing_Pages_ExportReportDemo.cb1}">

                                <af:exportCollectionActionListener type="excelHTML"

                                                                   exportedId="resId1"/>

                </h:commandButton>

             

S5. Now run the Application you will get the below output.

                                                     

S6. Now click on Export to Excel button you will find below screen.

                                            

S7. Now open/save the report it will looks like below screen.

                                           

               

Guys you can download the application from the below url.

                               ExportReportApp

Thanks a lot guys for hearing me.