Interface ISheetData
Used in conjunction with RowMaxCount.
Inherited Members
Namespace: Syncfusion.XlsIO.Calculate
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public interface ISheetData : ICalcDataRemarks
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 |