menu

Xamarin.Android

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface ISheetData - Xamarin.Android API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface ISheetData

    Used in conjunction with RowMaxCount.

    Inherited Members
    ICalcData.add_ValueChanged(ValueChangedEventHandler)
    ICalcData.GetValueRowCol(Int32, Int32)
    ICalcData.remove_ValueChanged(ValueChangedEventHandler)
    ICalcData.SetValueRowCol(Object, Int32, Int32)
    ICalcData.ValueChanged
    ICalcData.WireParentObject()
    Namespace: Syncfusion.Calculate
    Assembly: Syncfusion.Calculate.Android.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

    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved