workbookRangeView resource type

Namespace: microsoft.graph Represents a set of visible cells of the parent range.

Methods

Method	Return Type	Description
List rows	workbookRangeView collection	Get a workbookRangeView object collection.
Get item at	workbookRangeView	Get a range view item based in index.
Get range	workbookRange	Get the range object associated with the range view

Properties

Property	Type	Description
cellAddresses	Json	The cell addresses.
columnCount	Int32	The number of visible columns. Read-only.
formulas	Json	The formula in A1-style notation.
formulasLocal	Json	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.
formulasR1C1	Json	Represents the formula in R1C1-style notation.
index	Int32	The index of the range.
numberFormat	Json	Excel's number format code for the given cell. Read-only.
rowCount	Int32	The number of visible rows. Read-only.
text	Json	The text values of the specified range. The Text value won't depend on the cell width. The # sign substitution that happens in Excel UI won't affect the text value returned by the API. Read-only.
valueTypes	Json	The type of data of each cell. Read-only. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error.
values	Json	The raw values of the specified range view. The data returned could be of type string, number, or a Boolean. Cell that contains an error returns the error string.

Relationships

Relationship	Type	Description
rows	workbookRangeView collection	The collection of range views associated with the range. Read-only. Read-only.

JSON representation

The following JSON representation shows the resource type.

{
  "cellAddresses": "Json",
  "columnCount": 1024,
  "formulas": "Json",
  "formulasLocal": "Json",
  "formulasR1C1": "Json",
  "index": 1024,
  "numberFormat": "Json",
  "rowCount": 1024,
  "text": "Json",
  "valueTypes": "Json",
  "values": "Json"
}