first of all you should create library
or you should create two packages in Programm Unit
name is
1. RPT2XLS (Package Spec)
2. RPT2XLS (Package Body)
and in each you should describe the row and column and each thing of related to excell.
then you go to LAYOUT MODEL
and create a button name is U_EXCEL1
and type is = pl/sql
and call
RPT2XLS.RUN;
Then you define to each field that where you put like
example
------------ --------- Code for Report Header (ABDUL KHALIQUE 08/08/08)--- --------- --------- ---
RPT2XLS.put_ cell(1, 'GL/Account Code :', FontSize => 8,FontStyle => RPT2XLS.BOLD+ RPT2XLS.ITALIC+ RPT2XLS.UNDERLINE) ;
RPT2XLS.put_ cell(1, 'GL/Account Code :', FontSize => 8,FontStyle => RPT2XLS.BOLD+ RPT2XLS.ITALIC+ RPT2XLS.UNDERLINE) ;
This comment has been removed by a blog administrator.
ReplyDeletehELLO , i USED aBOVE 1. RPT2XLS (Package Spec)
Delete2. RPT2XLS (Package Body)
i m NOT ABLE TO EXPORT REPORT DATA , ITS EXPORTING ONLY HEADERD..
I m not able to export report to excle
Delete