Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 679
  • Last Modified:

Read from Excel into Oracle Forms on the web

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
russelltp
Asked:
russelltp
  • 3
  • 2
1 Solution
 
Helena Markováprogrammer-analystCommented:
This document can help you:
http://otn.oracle.com/products/forms/pdf/ClientSideOLE.pdf

The registration on OTN is free.
0
 
russelltpAuthor Commented:
Is this document saying that you cannot add OLE integration code to web deployed applications unless you used Java coding?  
0
 
Helena Markováprogrammer-analystCommented:
0
 
russelltpAuthor Commented:
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
 
Helena Markováprogrammer-analystCommented:
I think that you can do it.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now