Home » Developer & Programmer » Forms » How to export a SQL to MS-EXCEL in FORMS (ORACLE FORMS 6i)
How to export a SQL to MS-EXCEL in FORMS [message #590393] Wed, 17 July 2013 10:45 Go to next message
gtanoira
Messages: 9
Registered: July 2013
Junior Member
Hi Guys,
Here is my work for almost 1 week to create, debug and document this topic.
I create this because I need a way to export SQL commands in several forms to Excel without using CSV files. So this routine opens MS-Excel automaticaly and then export the data of the SQL into a sheet within the excel. Is a procedure that can be use in any form and using simple or complex SQLs.

The only thing is that the documentation is in spanish. In a later post I will send it in english. Sorry for this inconvenience.
I compressed 3 files in the TXT file. So, first change the extension from TXT to RAR and then unzipped the file.
Regards,
Gonzalo
Re: How to export a SQL to MS-EXCEL in FORMS [message #590478 is a reply to message #590393] Thu, 18 July 2013 09:04 Go to previous messageGo to next message
gtanoira
Messages: 9
Registered: July 2013
Junior Member
File 1: Documentation in PDF
Re: How to export a SQL to MS-EXCEL in FORMS (FILE 2) [message #590479 is a reply to message #590393] Thu, 18 July 2013 09:06 Go to previous messageGo to next message
gtanoira
Messages: 9
Registered: July 2013
Junior Member
File 2: CODE for PROCEDURE EXPORT_EXECEL-bySQL
Re: How to export a SQL to MS-EXCEL in FORMS (FILE 3) [message #590480 is a reply to message #590393] Thu, 18 July 2013 09:06 Go to previous messageGo to next message
gtanoira
Messages: 9
Registered: July 2013
Junior Member
File 3: Code for the TRIGGER WHEN-IMAGE-PRESSED
Re: How to export a SQL to MS-EXCEL in FORMS (FILE 2 - CHOOSE THIS) [message #590482 is a reply to message #590393] Thu, 18 July 2013 09:19 Go to previous messageGo to next message
gtanoira
Messages: 9
Registered: July 2013
Junior Member
FILE 2: code for PROCEDURE Export_excel_bySQL

The other FILE 2 doesn't work. (I don't know, technologies wonders! I guess! jeje!)
Re: How to export a SQL to MS-EXCEL in FORMS (FILE 2 - CHOOSE THIS) [message #590541 is a reply to message #590482] Fri, 19 July 2013 03:15 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for sharing it with the community! I hope people will find it useful!
Re: How to export a SQL to MS-EXCEL in FORMS (ENGLISH DOCUMENTATION) [message #590592 is a reply to message #590393] Fri, 19 July 2013 08:40 Go to previous message
gtanoira
Messages: 9
Registered: July 2013
Junior Member
As promised, here is the english version of the documentation.
Enjoy.
Gonzalo
Previous Topic: Wait event during execution simple "select" statement
Next Topic: how to generate XML data of SQL query through forms 10g
Goto Forum:
  


Current Time: Fri Apr 26 05:08:29 CDT 2024