Package com.microsoft.graph.models

Class WorkbookRange

java.lang.Object
com.microsoft.graph.models.Entity
com.microsoft.graph.models.WorkbookRange
All Implemented Interfaces:
com.microsoft.kiota.serialization.AdditionalDataHolder, com.microsoft.kiota.serialization.Parsable, com.microsoft.kiota.store.BackedModel
@Generated("com.microsoft.kiota") public class WorkbookRange extends Entity implements com.microsoft.kiota.serialization.Parsable

  • Constructor Details

    • WorkbookRange

      public WorkbookRange()
      Instantiates a new WorkbookRange and sets the default values.

  • Method Details

    • createFromDiscriminatorValue

      @Nonnull public static WorkbookRange createFromDiscriminatorValue(@Nonnull com.microsoft.kiota.serialization.ParseNode parseNode)
      Creates a new instance of the appropriate class based on discriminator value
      Parameters:
      parseNode - The parse node to use to read the discriminator value and create the object
      Returns:
      a WorkbookRange

    • getAddress

      @Nullable public String getAddress()
      Gets the address property value. Represents the range reference in A1-style. Address value contains the Sheet reference (for example, Sheet1!A1:B4). Read-only.
      Returns:
      a String

    • getAddressLocal

      @Nullable public String getAddressLocal()
      Gets the addressLocal property value. Represents range reference for the specified range in the language of the user. Read-only.
      Returns:
      a String

    • getCellCount

      @Nullable public Integer getCellCount()
      Gets the cellCount property value. Number of cells in the range. Read-only.
      Returns:
      a Integer

    • getColumnCount

      @Nullable public Integer getColumnCount()
      Gets the columnCount property value. Represents the total number of columns in the range. Read-only.
      Returns:
      a Integer

    • getColumnHidden

      @Nullable public Boolean getColumnHidden()
      Gets the columnHidden property value. Indicates whether all columns of the current range are hidden.
      Returns:
      a Boolean

    • getColumnIndex

      @Nullable public Integer getColumnIndex()
      Gets the columnIndex property value. Represents the column number of the first cell in the range. Zero-indexed. Read-only.
      Returns:
      a Integer

    • getFieldDeserializers

      @Nonnull public Map<String,Consumer<com.microsoft.kiota.serialization.ParseNode>> getFieldDeserializers()
      The deserialization information for the current model
      Specified by:
      getFieldDeserializers in interface com.microsoft.kiota.serialization.Parsable
      Overrides:
      getFieldDeserializers in class Entity
      Returns:
      a Map<String,Consumer<com.microsoft.kiota.serialization.ParseNode>>

    • getFormat

      @Nullable public WorkbookRangeFormat getFormat()
      Gets the format property value. Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
      Returns:
      a WorkbookRangeFormat

    • getFormulas

      @Nullable public com.microsoft.kiota.serialization.UntypedNode getFormulas()
      Gets the formulas property value. Represents the formula in A1-style notation.
      Returns:
      a UntypedNode

    • getFormulasLocal

      @Nullable public com.microsoft.kiota.serialization.UntypedNode getFormulasLocal()
      Gets the formulasLocal property value. Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English '=SUM(A1, 1.5)' formula would become '=SUMME(A1; 1,5)' in German.
      Returns:
      a UntypedNode

    • getFormulasR1C1

      @Nullable public com.microsoft.kiota.serialization.UntypedNode getFormulasR1C1()
      Gets the formulasR1C1 property value. Represents the formula in R1C1-style notation.
      Returns:
      a UntypedNode

    • getHidden

      @Nullable public Boolean getHidden()
      Gets the hidden property value. Represents if all cells of the current range are hidden. Read-only.
      Returns:
      a Boolean

    • getNumberFormat

      @Nullable public com.microsoft.kiota.serialization.UntypedNode getNumberFormat()
      Gets the numberFormat property value. Represents Excel's number format code for the given cell.
      Returns:
      a UntypedNode

    • getRowCount

      @Nullable public Integer getRowCount()
      Gets the rowCount property value. Returns the total number of rows in the range. Read-only.
      Returns:
      a Integer

    • getRowHidden

      @Nullable public Boolean getRowHidden()
      Gets the rowHidden property value. Indicates whether all rows of the current range are hidden.
      Returns:
      a Boolean

    • getRowIndex

      @Nullable public Integer getRowIndex()
      Gets the rowIndex property value. Returns the row number of the first cell in the range. Zero-indexed. Read-only.
      Returns:
      a Integer

    • getSort

      @Nullable public WorkbookRangeSort getSort()
      Gets the sort property value. The worksheet containing the current range. Read-only.
      Returns:
      a WorkbookRangeSort

    • getText

      @Nullable public com.microsoft.kiota.serialization.UntypedNode getText()
      Gets the text property value. Text values of the specified range. The Text value doesn't depend on the cell width. The # sign substitution that happens in Excel UI doesn't affect the text value returned by the API. Read-only.
      Returns:
      a UntypedNode

    • getValues

      @Nullable public com.microsoft.kiota.serialization.UntypedNode getValues()
      Gets the values property value. Represents the raw values of the specified range. The data returned can be of type string, number, or a Boolean. Cell that contains an error returns the error string.
      Returns:
      a UntypedNode

    • getValueTypes

      @Nullable public com.microsoft.kiota.serialization.UntypedNode getValueTypes()
      Gets the valueTypes property value. Represents the type of data of each cell. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error. Read-only.
      Returns:
      a UntypedNode

    • getWorksheet

      @Nullable public WorkbookWorksheet getWorksheet()
      Gets the worksheet property value. The worksheet containing the current range. Read-only.
      Returns:
      a WorkbookWorksheet

    • serialize

      public void serialize(@Nonnull com.microsoft.kiota.serialization.SerializationWriter writer)
      Serializes information the current object
      Specified by:
      serialize in interface com.microsoft.kiota.serialization.Parsable
      Overrides:
      serialize in class Entity
      Parameters:
      writer - Serialization writer to use to serialize this model

    • setAddress

      public void setAddress(@Nullable String value)
      Sets the address property value. Represents the range reference in A1-style. Address value contains the Sheet reference (for example, Sheet1!A1:B4). Read-only.
      Parameters:
      value - Value to set for the address property.

    • setAddressLocal

      public void setAddressLocal(@Nullable String value)
      Sets the addressLocal property value. Represents range reference for the specified range in the language of the user. Read-only.
      Parameters:
      value - Value to set for the addressLocal property.

    • setCellCount

      public void setCellCount(@Nullable Integer value)
      Sets the cellCount property value. Number of cells in the range. Read-only.
      Parameters:
      value - Value to set for the cellCount property.

    • setColumnCount

      public void setColumnCount(@Nullable Integer value)
      Sets the columnCount property value. Represents the total number of columns in the range. Read-only.
      Parameters:
      value - Value to set for the columnCount property.

    • setColumnHidden

      public void setColumnHidden(@Nullable Boolean value)
      Sets the columnHidden property value. Indicates whether all columns of the current range are hidden.
      Parameters:
      value - Value to set for the columnHidden property.

    • setColumnIndex

      public void setColumnIndex(@Nullable Integer value)
      Sets the columnIndex property value. Represents the column number of the first cell in the range. Zero-indexed. Read-only.
      Parameters:
      value - Value to set for the columnIndex property.

    • setFormat

      public void setFormat(@Nullable WorkbookRangeFormat value)
      Sets the format property value. Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.
      Parameters:
      value - Value to set for the format property.

    • setFormulas

      public void setFormulas(@Nullable com.microsoft.kiota.serialization.UntypedNode value)
      Sets the formulas property value. Represents the formula in A1-style notation.
      Parameters:
      value - Value to set for the formulas property.

    • setFormulasLocal

      public void setFormulasLocal(@Nullable com.microsoft.kiota.serialization.UntypedNode value)
      Sets the formulasLocal property value. Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English '=SUM(A1, 1.5)' formula would become '=SUMME(A1; 1,5)' in German.
      Parameters:
      value - Value to set for the formulasLocal property.

    • setFormulasR1C1

      public void setFormulasR1C1(@Nullable com.microsoft.kiota.serialization.UntypedNode value)
      Sets the formulasR1C1 property value. Represents the formula in R1C1-style notation.
      Parameters:
      value - Value to set for the formulasR1C1 property.

    • setHidden

      public void setHidden(@Nullable Boolean value)
      Sets the hidden property value. Represents if all cells of the current range are hidden. Read-only.
      Parameters:
      value - Value to set for the hidden property.

    • setNumberFormat

      public void setNumberFormat(@Nullable com.microsoft.kiota.serialization.UntypedNode value)
      Sets the numberFormat property value. Represents Excel's number format code for the given cell.
      Parameters:
      value - Value to set for the numberFormat property.

    • setRowCount

      public void setRowCount(@Nullable Integer value)
      Sets the rowCount property value. Returns the total number of rows in the range. Read-only.
      Parameters:
      value - Value to set for the rowCount property.

    • setRowHidden

      public void setRowHidden(@Nullable Boolean value)
      Sets the rowHidden property value. Indicates whether all rows of the current range are hidden.
      Parameters:
      value - Value to set for the rowHidden property.

    • setRowIndex

      public void setRowIndex(@Nullable Integer value)
      Sets the rowIndex property value. Returns the row number of the first cell in the range. Zero-indexed. Read-only.
      Parameters:
      value - Value to set for the rowIndex property.

    • setSort

      public void setSort(@Nullable WorkbookRangeSort value)
      Sets the sort property value. The worksheet containing the current range. Read-only.
      Parameters:
      value - Value to set for the sort property.

    • setText

      public void setText(@Nullable com.microsoft.kiota.serialization.UntypedNode value)
      Sets the text property value. Text values of the specified range. The Text value doesn't depend on the cell width. The # sign substitution that happens in Excel UI doesn't affect the text value returned by the API. Read-only.
      Parameters:
      value - Value to set for the text property.

    • setValues

      public void setValues(@Nullable com.microsoft.kiota.serialization.UntypedNode value)
      Sets the values property value. Represents the raw values of the specified range. The data returned can be of type string, number, or a Boolean. Cell that contains an error returns the error string.
      Parameters:
      value - Value to set for the values property.

    • setValueTypes

      public void setValueTypes(@Nullable com.microsoft.kiota.serialization.UntypedNode value)
      Sets the valueTypes property value. Represents the type of data of each cell. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error. Read-only.
      Parameters:
      value - Value to set for the valueTypes property.

    • setWorksheet

      public void setWorksheet(@Nullable WorkbookWorksheet value)
      Sets the worksheet property value. The worksheet containing the current range. Read-only.
      Parameters:
      value - Value to set for the worksheet property.