workbookRangeView resource type
Namespace: microsoft.graph 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 |
---|---|---|
cellAddresses | Json | Represents the cell addresses |
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. The 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",
"index": 1024,
"numberFormat": "Json",
"rowCount": 1024,
"text": "Json",
"valueTypes": "Json",
"values": "Json"
}
Commenti e suggerimenti
https://aka.ms/ContentUserFeedback.
Presto disponibile: Nel corso del 2024 verranno gradualmente disattivati i problemi di GitHub come meccanismo di feedback per il contenuto e ciò verrà sostituito con un nuovo sistema di feedback. Per altre informazioni, vedereInvia e visualizza il feedback per