Oracle Forms (MOSC)

MOSC Banner

How to get total number of printable pages in an excel sheet using client_ole2?

edited Mar 23, 2012 5:17PM in Oracle Forms (MOSC) 2 commentsAnswered
Hi,

I tried to get the total number of printable pages in an excel sheet using client_ole2 but couldn't.

I used the below code with excel 2007:

declare

  v_app        client_ole2.obj_type;
  v_docs       client_ole2.obj_type;
  v_doc        client_ole2.obj_type;
  v_worksheet     client_ole2.obj_type;
  v_VPageBreak    client_ole2.obj_type;
  v_page_num     number(3) := 1;
begin

    v_app := CLIENT_OLE2.CREATE_OBJ('Excel.Application');
    CLIENT_OLE2.SET_PROPERTY(v_app,'Visible',0);  -- 0
    v_docs := CLIENT_OLE2.GET_OBJ_PROPERTY(v_app, 'Workbooks');
    v_args := CLIENT_OLE2.create_arglist;
    CLIENT_OLE2.add_arg(v_args, 'C:\test.xls');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center