I am evaluating Aspose.cells for .net. I wonder what is the allowed max rows and columns.
Hi,
Aspose.Cells follows MS Excel standards for different file format types, it does not put any restrictions regarding rows and columns rather the limitations depend on which file format type you are using.
1) If your Excel file is in XLS (Excel 97-2003) file format, your maximum row would be 65536 (this is the last row in the sheet) and you can have maximum columns up to 256. This is the limitation put forth by MS Excel for XLS file format, there is nothing to do with Aspose.Cells product.
2) If your Excel file is in the XLSX file format (Excel 2007/2010 or newer versions), then you may have much more i.e. up to 1048576 rows and lots of columns.
Hope, it helps you a bit.
Thank you.
Thanks for your help.
I have another inquiry. Hope you also can help me. I can get all data of excel file with a trial version? In other words, the trial version has a limition for
reading the data(e.g. controls, rows, columns, shapes, charts).
Thanks and regards,
Jack
Hi Jack,
Thank you for writing back.
Aspose.Cells for .NET API does not impose any such restricts as mentioned in your post. In evaluation mode, Aspose.Cells for .NET API restricts the number of Workbooks that can be opened. Moreover, an extra worksheet containing the Evaluation message will be added to the resultant spreadsheet. I would suggest you to go through the below linked technical articles on this subject.
http://www.aspose.com/docs/display/cellsnet/Licensing
http://www.aspose.com/docs/display/cellsnet/Evaluate+Aspose.Cells
If you would like an evaluation license to test without any restrictions for 30 days, please follow the directions provided here.
Please feel free to write back in case you have any ambiguity or need our further assistance.