workbookRangeView resource type
Namespace: microsoft.graph
Important
APIs under the /beta version in Microsoft Graph are subject to change. Use of these APIs in production applications is not supported. To determine whether an API is available in v1.0, use the Version selector.
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 ange | workbookRange | Get the range object associated with the range view |
Properties
| Property | Type | Description |
|---|---|---|
| cellAddresses | Json | Represents 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. 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",
"id": "String (identifier)",
"index": 1024,
"numberFormat": "Json",
"rowCount": 1024,
"text": "Json",
"valueTypes": "Json",
"values": "Json"
}