Represents Data provider for saving large spreadsheet files in light weight mode.
public interface LightCellsDataProvider
|IsGatherString()||Checks whether the current string value of cell needs to be gathered into a global pool.|
|NextCell()||Gets next cell to be saved.|
|NextRow()||Gets the next row to be saved.|
|StartCell(Cell)||Starts to save data of one cell.|
|StartRow(Row)||Starts to save data of one row.|
|StartSheet(int)||Starts to save a worksheet.|
When saving a workbook by this mode,
StartSheet will be checked when saving every worksheet in the workbook. For one sheet, if
StartSheet gives true, then all data and properties of rows/cells of this sheet to be saved will be provided by the implementation of this interface. In the first place,
NextRow will be called to get the next row index to be saved. If a valid row index is returned(the row index must be in ascending order for the rows to be saved), then a Row object representing this row will be provided for implementation to set its properties by
StartRow. For one row,
NextCell will be checked firstly. If a valid column index be returned(the column index must be in ascending order for all cells of one row to be saved), then a Cell object representing this cell will be provided for implementation to set its data and properties by
StartCell. After data of this cell is set, this cell will be saved directly to the generated spreadsheet file and the next cell will be checked and processed.