Results 1 to 3 of 3

Thread: Oracle To Excel

  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Unhappy Unanswered: Oracle To Excel

    HI EVERY ONE,


    CAN ANY ONE HELP ME TO RUN AN ECXEL REPORT ON ORACLE 9i??
    WHERE IN MY PROGRAM I WANT TO ADD 2 TYPE OF REPORT ONE IN ORACLE REPPRT AND THE OTHER IS EXCEL??



    THNX


    SAKI / BAHRAIN

  2. #2
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    Try searching for *.xls in your Oracle directory. There should be a sample file with Oracle Objects for OLE code. That should get you started.

  3. #3
    Join Date
    Mar 2004
    Posts
    7

    Angry oracle to excel

    i did't found

    i use this code

    DECLARE
    APPLICATION PLS_INTEGER;
    WORKBOOKS PLS_INTEGER;
    ARGS PLS_INTEGER;
    WORKBOOK PLS_INTEGER;
    WORKSHEETS PLS_INTEGER;
    WORKSHEET PLS_INTEGER;
    BEGIN
    APPLICATION:=CLIENT_OLE2.CREATE_OBJ('EXCEL.APPLICA TION');
    CLIENT_OLE2.SET_PROPERTY(APPLICATION,'VISIBLE',1);
    WORKBOOKS:=CLEINT_OLE2.GET_OBJ_PROPERTY (APPLICATION,'WORKBOOKS');
    ARGS:=CLIENT_OLE2.CREATE_ARGLIST;
    CLIENTS_OLE2.ADD_ARG(ARGS,FILE);
    WORKBOOK:=CLIENT_OLE2.GET_OGJ_PROPERTY (WOORKBOOKS,'OPEN',ARGS);
    CLIENT_OLE2.DESTROY_ARGLIST(ARGS);
    WORKSHEETS:=CLIENT_OLE2.GET_OBJ_PROPERTY (WORKBOOK,'WORKSHEETS');
    WORKSHEET:=CLIENT_OLE2.GET_OBJ_PROPERTY(WORKSHEETS ,'ADD');
    END;




    the error here it ask me to declear CLIENTS_OLE2.ADD_ARG(ARGS,FILE); / WORKBOOK:=CLIENT_OLE2.GET_OGJ_PROPERTY (WOORKBOOKS,'OPEN',ARGS);/

    WORKSHEET:=CLIENT_OLE2.GET_OBJ_PROPERTY(WORKSHEETS ,'ADD');



    can some one help me plz
    Last edited by SAKI; 03-14-04 at 05:45.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •