Home » Developer & Programmer » Forms » reading multiple excel file using WEBUTIL functions (ORACLE forms 10G (9.0.4))
reading multiple excel file using WEBUTIL functions [message #279435] Thu, 08 November 2007 06:50 Go to next message
kenjio
Messages: 7
Registered: November 2007
Junior Member
Hi All,
Im new in this forum,I have a project loading multiple excel files using oracle forms 10g(9.0.4),Ive sucessfully loaded it using DDE but only one excel file can handle.I configured a WEBUTIL successfully, but i dont know what WEBUTIL functions Am I going to use to fetched multiple excel files,Somebody can provide a sample code will be a great help.Thanks a lot.

Kenji

Report message to a moderator

Re: reading multiple excel file using WEBUTIL functions [message #279546 is a reply to message #279435] Thu, 08 November 2007 23:44 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
To fetch multiple files, fetch one, do your processing, then fetch the next one, etcetera.

David

Report message to a moderator

Re: reading multiple excel file using WEBUTIL functions [message #279739 is a reply to message #279546] Fri, 09 November 2007 23:28 Go to previous messageGo to next message
kenjio
Messages: 7
Registered: November 2007
Junior Member
Hi David,
Thanks for the reply,but how do i do that, what commands or functions in webutil am i going to use to fetch, im new in ORACLE GUI and still learning, Im from UNIX text base.please help.. Thanks

KENJI

Report message to a moderator

Re: reading multiple excel file using WEBUTIL functions [message #280524 is a reply to message #279739] Wed, 14 November 2007 00:05 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
The following are the standard set of Excel threads:
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
http://www.orafaq.com/forum/m/84230/67467/
Merge two cells in Excel using ole2
http://www.orafaq.com/forum/t/77825/67467/
Error closing Excel file generated using OLE2
http://www.orafaq.com/forum/t/77351/67467/
How to wrap text in excel cell using ole2
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830d62336f40f5aad44efb36ee981f4e6c19e.e34QbhuKaxmMai0MaNeMb3eKb390?mess ageID=1242535&#1242535
Forms to Excel example with webutil
http://forums.oracle.com/forums/thread.jspa?messageID=1430799
Another Forms to Excel example
http://www.orafaq.com/forum/t/81537/67467/
http://www.orafaq.com/forum/t/32353/67467/
How to kill EXCEL.exe from Task Manager from Oracle Forms
http://www.orafaq.com/forum/t/88643/67467/
how do i display all excel worksheets name in form
http://www.orafaq.com/forum/t/89775/67467/
More Excel stuff
http://www.orafaq.com/forum/t/90502/67467/
To run an excel macro
http://www.orafaq.com/forum/t/47685/67467/

David

Report message to a moderator

Previous Topic: Help me please with WEBUTIL_CLIENT_OLE2
Next Topic: Returning Multiple result sets
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 22:03:28 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.