Due to some high memory usage issues, I am trying to evaluate com.aspose.cells.LightCells classes provided by Aspose. I tried looking for the API documentation of the same. I did not get it in the online documentation also.
can you please send me the documentations of LightCells and related classes? So that I can use it effectively.
I have progressed well using the references. However, I have another question.
When I process a sheet using lightCells.processWorksheet(0, handler), the processing by default starts from first valid cell. But, in my sheets there are multiple tables. I want to read particular table only. In other words how can I configure the handler to read only a specific matrix not the whole active area.
The methods startSheet() and startCell() in CellHandler is to inform client application that LightCells processor encounters one new sheet/cell, that is, this method will be invoked by LightCells for every sheet/cell. If client application wants to process this sheet/cell, then this method should return true, so LightCells will parse data for this cell and invoke method process() on it; Otherwise return false, then LightCells processor will ignore this sheet/cell and move to next sheet/cell.
To process part of all cells, I think you can implement your startCell() method of CellHandler as following: