Excel Financial Functions

Hi,

I want to use excel IRR, PMT and Rate functions. Do aspose cell library supports them?

If yes, could you please guide me the namespace and usage?

thanks,

Shreyash

Hi,


Yes, these functions are supported by Aspose.Cells formula calculation engine, see the document:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/supported-formulas-functions.html
If you find any issue with these function, kindly give us your template file with sample code, we will check it soon.


Also, see the documents how you may set formulas or calculate formulas at run time:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/using-formulasfunctions-to-process-data.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/calculating-formulas.html


Thank you.