Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Angry Unanswered: creating an excel sheet using OLE2

    I'm using OLE2 to create an excel sheet from FORMS6.0 application.
    I've encountered the following problems:
    1. The excel opens with a default sheet. I created new sheets, but I can't use or get rid of the first original sheet which is empty. How do I write to it or delete it?

    2. I would like to highlight certain rows (bright yellow), and have certain cells bold. How is that done?

    3. How do I rename a sheet?
    Last edited by aderette; 08-13-03 at 02:12.

  2. #2
    Join Date
    Aug 2003
    Posts
    1
    1. Didn't have this problem yet.

    2.Look at my example how i make tekst in first row bolded:

    declare

    MyApplication OLE2.OBJ_TYPE;
    selection OLE2.OBJ_TYPE;
    row OLE2.OBJ_TYPE;
    font OLE2.OBJ_TYPE;
    args OLE2.LIST_TYPE;

    begin

    MyApplication:=OLE2.CREATE_OBJ('Excel.Application' );

    args:=OLE2.CREATE_ARGLIST;
    OLE2.ADD_ARG(args, 1);
    row:=OLE2.GET_OBJ_PROPERTY(worksheet, 'Rows', args);
    OLE2.DESTROY_ARGLIST(args);

    OLE2.SET_PROPERTY(row, 'Select', 1);
    selection:=OLE2.GET_OBJ_PROPERTY(myapplication, 'Selection');
    font:= ole2.GET_OBJ_PROPERTY(Selection, 'Font');
    OLE2.SET_PROPERTY(font, 'Bold', 1);

    end;

    3. Don't know.


    Ales; ORACLE DBA,PROGRAMER; Slovenia.

Posting Permissions

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