Dear all
i need your help to know
1-how to call excel sheet from oracle application forms
2-how to calculate Internal Rate of Return (IRR) from oracle
Best regards

To call the excel sheet from the form (static excel sheet) on a CUSTOM form u can use web.showdocument and the path of the excel sheet on the server .
if u have a request and u want to view the output on excel then u have to setup a viewer of type excel and assign it to that request
2) pls provide more explanation on the IRR to be able to help u

Dear Sir

1) I mean by call excel, to put values on excel sheet from the form (in oracle application) from example when I click on the button from the form, insert data on excel sheet.

2) IRR is ready formula in excel but on oracle is not found so i ask if any one know how to calculate it

Best regards

for the excel population this is already present by the export functionality from the form in the file menu you 'll find an export option to export the queried data to excel sheet directly
(this uses appcore pll code which u can use also if the export is not enabled on this form(
for the IRR i still need to understand the formula and how do u want to implement it to figure out if i can help u in that

Dear Sir if you means how to compy values from you form to Excel File then contact me on thaer_q@hotmail i wil provide you with example for that