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.
RangeView represents a set of visible cells of the parent range.
Methods
Method | Return Type | Description |
---|---|---|
List rows | workbookRangeView collection | Get a workbookRangeView object collection. |
Itemat | workbookRangeView | Get a range view item based in index. |
Range | workbookRange | Return the range object associated with the range view |
Properties
Property | Type | Description |
---|---|---|
columnCount | Int32 | Returns the number of visible columns. Read-only. |
formulas | Json | Represents the formula in A1-style notation. |
formulasLocal | Json | 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. |
formulasR1C1 | Json | Represents the formula in R1C1-style notation. |
index | Int32 | Index of the range. |
numberFormat | Json | Represents Excel's number format code for the given cell. Read-only. |
rowCount | Int32 | Returns the number of visible rows. Read-only. |
text | Json | 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 | Represents the type of data of each cell. Read-only. Possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error. |
values | Json | Represents 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 | Represents a 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"
}
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for