How to get total number of printable pages in an excel sheet using client_ole2?
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');