Sharing a form to generate Excel file report from SQL query in Oracle Forms. This form can be used in Oracle Forms 6i and 10g / 11g.

Below is the screen shot of this form and could be download from the following link:


A procedure Create_Excel_File is attached in Program Unit of the form, which is being called from the "Generate Excel Report" push button and the following code is written on When-Button-Pressed trigger:

declare
vstring varchar2(4000);
begin
vstring := rtrim(replace(replace(:sql_query, chr(10),''), chr(13),''), ';');
Create_excel_file(vstring);
end;

Note: Excel Report will be created and open automatically in New Excel Instance.

See more examples of using OLE object in Oracle Forms from the following links:

Subscribe To Get Email Notifications For Latest Updates Like This:
Enter your email address:


Delivered by FeedBurner

Ask Your Questions By Comment Below.

Providing source code an FMB file for generating excel format report from sql query in oracle forms.

Post a Comment

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.