Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Read from Excel into Oracle Forms on the web

Posted on 2003-10-31
5
Medium Priority
?
674 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 75 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

718 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