0 Replies Latest reply: Mar 30, 2011 12:34 AM by 535878 RSS

    excel to pdf

    535878
      Hi,

      Iam able to generate excel from my Form using ole2 package.

      Iam using forms 6i and database 10g.

      Following is the procedure to save the file to excel

      Procedure save_xl(p_path varchar2,p_excel_name varchar2) is
      Begin

      OLE2.Release_Obj(worksheet);
      OLE2.Release_Obj(worksheets);

      If p_path is not null then
      Arglist := OLE2.Create_Arglist;
      OLE2.Add_Arg(Arglist,p_path||'\'||p_excel_name||'.xls');
      OLE2.Invoke(workbook, 'SaveAs', Arglist);
      OLE2.Destroy_Arglist(Arglist);
      end if;
      End;


      Now i want to publish pdf file from this generated excel file programatically. Please help

      Note : I tried modifying OLE2.Add_Arg(Arglist,p_path||'\'||p_excel_name||'.xls') to OLE2.Add_Arg(Arglist,p_path||'\'||p_excel_name||'.pdf')
      but it creates a pdf file but doesnt work. Because it is just saving the file as .pdf instead of .xls its not publising to pdf actually....


      Thanks in advance.