OraFAQ Forum: Forms » need to generate 1 excel with 11 worksheets

Home » Developer & Programmer » Forms » need to generate 1 excel with 11 worksheets (11g R1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

need to generate 1 excel with 11 worksheets [message #636499]

Mon, 27 April 2015 02:00

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

Report message to a moderator

Re: need to generate 1 excel with 11 worksheets [message #636544 is a reply to message #636499]

Mon, 27 April 2015 09:53

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...

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:30:53 CDT 2024