Sharing a form to generate Excel file for SQL query in Oracle Forms. This form can is used in Oracle Forms 6i and 10g/11g. Below is the shot of this form and could was download from the following LINK:EXCEL_REP.FMB A procedure Create_ Excel_file is attached in program Unit of the form, which was being called from the ' Generate Excel Report ' push button and The following code is written on when-button-pressed Trigger:declarevstring varchar2 (4000); BeginVstring: = RTrim (replace (: Sql_query, CHR, '), Chr (13), '), '; ');Create_excel_file (vstring); End
Note:excel report is created and open automatically in New Excel Instance.
See more examples of using OLE object with Oracle Forms from the following Links:http://www.foxinfotech.in/2013/02/format Ting-excel-file-using-ole2-in.html http://www.foxinfotech.in/2013/02/ Creating-excel-file-in-oracle-d2k-forms.html
Freebie-utility form:generate Excel report from SQL Query in Oracle Forms 6i and 11g