Interface ISheetData

Used in conjunction with RowMaxCount.

Inherited Members

ICalcData.ColumnCount

ICalcData.GetDependentCellValue(Int32, Int32)

ICalcData.GetValueRowCol(Int32, Int32)

ICalcData.RecalculateCell(Int32, Int32, Boolean)

ICalcData.RowCount

ICalcData.SetValueRowCol(Object, Int32, Int32)

ICalcData.ValueChanged

ICalcData.WireParentObject()

Namespace: Syncfusion.Windows.Forms.CellGrid

Assembly: Syncfusion.Spreadsheet.Windows.dll

Syntax

public interface ISheetData : ICalcData

Remarks

Essential Calculate supports column ranges of the form A:D as in =SUM(A:D) to represent all cells in columns A, B, C and D from a ICalcData object. To get a value for the number of rows, the CalcEngine first checks to see if the ICalcData object supports the ISheetData interface. If this interface is supported, the row count used to determine the range is obtained through this interface. If the ICalcData object does not support ISheetData, then the value of RowMaxCount is used provided RowMaxCount > 0. and the index of first and last rows and columns is used.

Methods

GetColumnCount()

Gets the column count.

Declaration

int GetColumnCount()

Returns

Type	Description
System.Int32	Number of columns

GetFirstColumn()

Gets the first column index.

Declaration

int GetFirstColumn()

Returns

Type	Description
System.Int32	Index of first column

GetFirstRow()

Get the idex of the first row in UsedRange

Declaration

int GetFirstRow()

Returns

Type	Description
System.Int32	index of first row

GetLastColumn()

Gets the last column index / column count.

Declaration

int GetLastColumn()

Returns

Type	Description
System.Int32	Index of last column

GetLastRow()

get the index of the last row in UsedRange

Declaration

int GetLastRow()

Returns

Type	Description
System.Int32	index of last row

GetRowCount()

Gets the row count.

Declaration

int GetRowCount()

Returns

Type	Description
System.Int32	Number of rows