We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells stream rows

Hi,

I wonder whether Aspose Cells allows us to stream rows of excel from an InputStream (basically, I don’t want to load the full excel into memory). i.e) everytime I read, I get one row of data from excel.

I went thorough the LightCells API, but it seems it streams with respect to a “Cell”.

Thanks

EDIT:
I noticed that when using LightCells API and when creating a new workbook itself, all the rows/cells are being iterated/accessed.
But I would want it to be done lazily, on demand (like, how the data is fetched only when we call read on an inputStream). Is it possible?


Hi,


Thanks for your posting and considering Aspose.Cells.

We are afraid, you cannot fetch data from excel files on demand. LightCells API will also load entire data into memory, so your requirements cannot be achieved with both Normal or LightCells mode.