Home » Developer & Programmer » Forms » need to generate 1 excel with 11 worksheets (11g R1)
need to generate 1 excel with 11 worksheets [message #636499] Mon, 27 April 2015 02:00 Go to next message
apariya
Messages: 1
Registered: April 2015
Location: pune
Junior Member
Hi All,

currently we are running 11 diffrent queries and exporting it to excel indvidually.. now client wants it like one excel with 11 worksheet for all 11 queries data.

could you please help in on this.. they want it to gets created in submit button of form 11g

Re: need to generate 1 excel with 11 worksheets [message #636544 is a reply to message #636499] Mon, 27 April 2015 09:53 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
A google search on: "Oracle Forms Excel Worksheet" gave me numerous hits. You should be able to use the Worksheet/Add OLE calls. Check out these links:
Forms to Excel example with webutil
How to loop through all excel sheets while opening an excel file from Oracle Forms Builder?
These are just a couple of hits returned by the aforementioned Google search...

Craig...
Previous Topic: ORACLE FORMS 10G - WEBUTIL
Next Topic: How to Get Windows Server Domain Name in Oracle Forms 6i (merged by mod)
Goto Forum:
  


Current Time: Fri Aug 14 10:09:38 CDT 2020