Home » Developer & Programmer » Forms » Print to excel format from Oracle Forms
Print to excel format from Oracle Forms [message #278843] Mon, 05 November 2007 23:06 Go to next message
nahian
Messages: 7
Registered: June 2007
Location: Bangladesh
Junior Member
Hello there

I am new to this forum and also in Oracle forms development.Can anyone plz help me in telling that how can I generate a report directly into excel format by pressing a button in oracle forms.

Needing an early response from anyone.

Thnks

Nahian
Re: Print to excel format from Oracle Forms [message #278922 is a reply to message #278843] Tue, 06 November 2007 05:22 Go to previous messageGo to next message
rikfair
Messages: 22
Registered: October 2006
Location: UK
Junior Member
Hi Nahian

One option would be to use mod_plsql to generate the report in html, which can be output using an excel mime type to display in excel. Use web.show_document to call the url.

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11270

Hope this helps
Re: Print to excel format from Oracle Forms [message #278929 is a reply to message #278922] Tue, 06 November 2007 05:44 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
My standard reply is: have a look at SYLK.

MHE
Re: Print to excel format from Oracle Forms [message #279539 is a reply to message #278929] Thu, 08 November 2007 23:15 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You could also use 'utl_file' or 'text_io' or 'client_text_io' and write to a 'csv' file.

David
Previous Topic: OLE2 package and Excel Application
Next Topic: How to assign hyperlink for excel cell via Ole2
Goto Forum:
  


Current Time: Sun Feb 09 20:50:33 CST 2025