Perform complex calculations in Excelfrom .NET

Aspose.Cells Product Family
1

Hi,


I have to read excel file from with in .NET application. This excel file is going to have huge & complex calculation written in it. Some cells will have long Formula implemented and their result will go input to other cells and so on. In the end I have to read some results which are going to be in fixed cells (row & column numbers are known). Can this be achieved by Aspose.

Thanks
Jeelani
2

Hi,


Thanks for your query.

I think Aspose.Cells suits your needs well. It has its own formula calculation engine. The APIs support to read/write Excel files, set and calculate MS Excel formulas at runtime. You can get the calculated results from the cells at runtime easily. We recommend you to kindly see the Aspose.Cells for .NET Docs and browse the documents (especially) in the section for your reference:
http://www.aspose.com/docs/display/cellsnet/Formulas

Let us know if you still have any queries or comments.

Thank you.