Free Support Forum - aspose.com

com.aspose.cells.LightCells - HTML Documentation Required

Hi,

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.

Thanks,
Malay

Hi,

Well, LightCells are our latest APIs which we just introduced it. We will update our online docs and provide some helping material related the APIs.

We will soon provide you the helping docs for LightCells here.

In the mean time, you may check the following threads:

http://www.aspose.com/community/forums/thread/125926/performance-of-aspose.aspx

http://www.aspose.com/community/forums/thread/125773/does-aspose.cell-for-java-support-event-driven-parsing.aspx

http://www.aspose.com/community/forums/thread/128176/lightcells-api-giving-the-exception-aspose-cells-for-java.aspx

Thank you.

Hi Amjad,

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.

Please help.

Regards,
Malay

Hi,

We will get back to you for your queries.

Thanks for being patient!

Hi Malay,

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:

private int startRow, endRow, startColumn, endColumn;
...
public boolean startCell(int row, int column)
{
if(row >= startRow && row <= endRow && column >= startColumn && column <= endColumn)
{
return true;
}
return false;
}
...

Thank you.