We’re using Aspose Cells for Java, version 20.2.
For processing large workbooks, the “Light” API works quite well.
For some use cases however, we need to process sheet B before processing sheet A. At the moment it is not possible to control this, as Aspose will call back into our provided
LightCellsDataHandler implementation in (what I assume to be) the workbook order of the sheets. In our use case, the processing of sheet A depends on state resulting from processing sheet B. As such, we are forced to use the full (non-light) model, which imposes additional performance implications, mainly total retained memory.
There seems to be nothing inherent in the Excel workbook formats (or the underlying ZIP file format for
XLSB) to prevent processing sheets in a specific order.
If there is a feature in the “Light Cells” API controlling this aspect of workbook processing, please let me know. Otherwise, I’d like to raise this as an improvement request, since if would allow us to improve performance for many of our Aspose Cells use cases.
Thanks in advance,