Hi,
I need to use Aspose cell for excel automation to replace interop that used to calculated excel data, is there is any limitation regarding size of excel file, size of sheets, number of sheets, size of formula calculation, supported excel functions like financial functions, array function (i.e. sumIF…) , can we have the list of supported functions too?
Regards,
Thanks for your query.
We think Aspose.Cells suits your needs well. There is no limitation on Aspose.Cells part as it follows MS Excel standards and specifications. There is no limitation regarding generated file’s size or size of the sheets in the workbook. You can have as many worksheets in the workbook as you want. Regarding supported formulas by Aspose.Cells formula calculation, well, it supports to read/write and calculate almost all the formulas of MS Excel, see the document for your reference:
(Note: the list might not be final as more and more formulas are supported with every new release of the product).
Should you have any further query, feel free to ask us, we will be happy to assist you soon.
@Amjad_Sahi
Thanks for your reply, another question, can I test all the functionalities using the trial version?
is there any limitation on the trial version?
how will the licensing module work? should I implement it on every call of Aspose functions/modules?
Regards,
Thanks for considering Aspose.Cells APIs.
We recommend you to test the Aspose.Cells in trial version or evaluation mode. In evaluation mode, Aspose.Cells works almost same as in license mode. However, it has two limitations.
1 - Whenever you create workbook or modify it or create chart image or sheet image, it places Evaluation Warning on them.
2 - Number of opened files in a thread should not exceed 100. When you open more than 100 Excel files, exception is thrown.
You need to set license only once, to change evaluation mode to license mode. License is an xml file with extension .lic. You must set the license before you execute any other code. For example consider this code, it sets the Aspose.Cells license.
C#
Aspose.Cells.License lic = new Aspose.Cells.License();
lic.SetLicense(licPath);
For more detail, please see this article.