Solved

Read from Excel into Oracle Forms on the web

Posted on 2003-10-31
5
659 Views
Last Modified: 2013-12-12
Hi, earlier on this weekend I was askign about how to read from an Excel Spreadsheet into an Oracle Forms 6i application. I figured it out, but now I am having problems when the application is on the web server. Excel is located locally on my hardrive, but the app can't open Excel from the web server, any ideas?  This is how I open excel:

application := OLE2.CREATE_OBJ('Excel.Application'); --opens blank excel app
      --ole2.set_property(application,'Visible','true');
      ole2.set_property(application,'Visible', 1 );

      workbooks := OLE2.GET_OBJ_PROPERTY(application, 'Workbooks'); --opens excel workbook
      args := OLE2.CREATE_ARGLIST;
ole2.add_arg(args,'c:\test.xls');

workbook := ole2.GET_OBJ_PROPERTY(workbooks,'Open',args); -- opens test.xls workbook
ole2.destroy_arglist(args); --destroy current argument list
args := OLE2.CREATE_ARGLIST; --creat new list
ole2.add_arg(args,1);
worksheet := ole2.GET_OBJ_PROPERTY(workbook,'Worksheets',args);
ole2.destroy_arglist(args);

Any ideas?
Do I have to convert the excel file to a OWC.spreadsheet? How do I do that?
0
Comment
Question by:russelltp
  • 3
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 25 total points
ID: 9669076
This document can help you:
http://otn.oracle.com/products/forms/pdf/ClientSideOLE.pdf

The registration on OTN is free.
0
 

Author Comment

by:russelltp
ID: 9671011
Is this document saying that you cannot add OLE integration code to web deployed applications unless you used Java coding?  
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 9676496
0
 

Author Comment

by:russelltp
ID: 9678386
Ok, now we are getting somewhere. WebUtil would the be perfect method, however, I am using Forms6i right now, with possibility of converting to 9i after the project is deployed. Maybe I could use Java Beans for now and then maybe switch over to web util to simplify things later?
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 9684709
I think that you can do it.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now