Handling Large Excel Files using Aspose cells

hi Team,
wanted to check if we have any updates on this ticket?
Thanks

@Mveerabaghu
We deeply apologize for any inconvenience caused to you. But this feature (Ticket ID: “CELLSNET-54534”) has not yet been implemented. This feature is quite complex, and we need more time to solve it. Once there is an update, we will notify you promptly. We will get back to you soon.

ok thanks for the update.
may i get a tentative date on this?

@Mveerabaghu
Thank you for your feedback. This task is quite complex. We have been working hard to support it. We need to further evaluate the follow-up work, and if possible, we will give you an approximate time. We will get back to you soon.

@Mveerabaghu
We are pleased to inform you that we have made significant progress in handling large files. We will support this feature by the end of June 2025. We will notify you immediately once there are any updates.

@Mveerabaghu,

This is to inform you that we have implemented the feature (Ticket ID: “CELLSNET-54534”) now. We have supported to cache cells data in disk instead of memory to solve OOM exception when loading large Excel files. The enhancement will be included in the upcoming release (Aspose.Cells v25.7) which may be released before the end of this week. You will be notified once the new release is published.

team, thanks for the update.
will this support usage from azure function as well ? as there we dont have control over the disk on this. could you share documentation around this if its already available?

@Mveerabaghu

For this function we provide one new option for MemorySetting:

MemorySetting.FileCache

corresponding api reference will be released together with next official version 25.7. It is similar with other options of Enum MemorySetting | Aspose.Cells for .NET API Reference such as MemorySetting.MemoryPreference, the extra requirement for it is local disk(temporary file) access. We also provide api to specify the directory for those temporary files(CellsHelper.SetCacheFolder(…)). But local file access is essential for this function. If your application cannot support IO operations on local file, we are afraid this function is unavailable.

The issues you have found earlier (filed as CELLSNET-54534) have been fixed in this update. This message was posted using Bugs notification tool by leoluo