call excel function - xIRR from the report

Hi,
I need to call an excell function, xIRR, from my report.
How can I do that?

Thanks,

Igor

Hi Igor,

This is a great feature request for a later release that is already on our list. Excel functions, like you intend to use, are not currently supported.

|||

Igor,

You could write your own custom xIRR function and use it in your report.

Jarret

|||

Here is something you could try assuming you have Excel installed on the server.

1. Create a .NET library assembly

2. Reference the Excel object model - COM tab, Microsoft Office Excel x.0 Object Library. This will create P/Invoke wrapper on top of the Excel function dll.

3. Try calling the Excel function you need. They are under Microsoft.Office.Interop.Excel.IWorksheetFunction namespace.