Forum Stats

  • 3,836,791 Users
  • 2,262,191 Discussions
  • 7,900,111 Comments

Discussions

excel to pdf

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.
This discussion has been closed.