LightCellsDataHandler

LightCellsDataHandler interface

Represents cells data handler for reading large spreadsheet files in light weight mode.

public interface LightCellsDataHandler

Methods

Name Description
ProcessCell(Cell) Starts to process one cell.
ProcessRow(Row) Starts to process one row.
StartCell(int) Prepares to process a cell.
StartRow(int) Prepares to process a row.
StartSheet(Worksheet) Starts to process a worksheet.

Remarks

When reading a workbook by this mode, StartSheet will be checked when reading every worksheet in the workbook. For one sheet, if StartSheet gives true, then all data and properties of rows/cells of this sheet will be checked and processed by the implementation of this interface. For every row, StartRow will be called to check whether it need to be processed. If a row needs to be processed, properties of this row will be read firstly and user can access its properties by ProcessRow. if row’s cells need to be processed too, then ProcessRow should returns true and then StartCell will be called for every existing cell in this row to check whether one cell need to be processed. If one cell needs to be processed, then ProcessCell will be called to process the cell by the implementation of this interface.

See Also