Let me correct my previous statement first, MS Excel imposes the restriction that XLSX file format could have 1026 manual page breaks whereas XLS format could have 1000 manual page breaks. Aspose.Cells seems to restrict the limit at 1024, that is not aligned with MS Excel specifications. We have logged a ticket in our bug tracking system to look further into this matter.
Regarding your questions, please find below the answers,
As Aspose.Cells APIs follow MS Excel’s guidelines and recommendations therefore you may not exceed the specified limitation while using Aspose.Cells APIs.
We are not sure how to generate spreadsheets using SAP BO because that is not our area of expertise. However, you may generated any file size using Aspose.Cells APIs while following the MS Excel guidelines.
We would like to know more details of your scenario, and possibly review your samples to propose a workaround for the situation.
- Limits are as follow,
As it seems you are merging spreadsheets and hitting the exception as stated in title of this thread, we need to review your source code as well as a few samples to replicate the said exception on our end. As soon as we have isolated the cause of exception, we will be in a better position to suggest a workaround for the situation.
Thank you for your understanding & cooperation.