workbookRange resource type
Namespace: microsoft.graph
Range represents a set of one or more contiguous cells such as a cell, a row, a column, block of cells, etc.
Methods
Method | Return Type | Description |
---|---|---|
Get Range | Range | Read properties and relationships of range object. |
Update | Range | Update Range object. |
Boundingrect | Range | Gets the smallest range object that encompasses the given ranges. For example, the GetBoundingRect of "B2:C5" and "D10:E15" is "B2:E16". |
Cell | Range | Gets the range object containing the single cell based on row and column numbers. The cell can be outside the bounds of its parent range, so long as it's stays within the worksheet grid. The returned cell is located relative to the top left cell of the range. |
Column | Range | Gets a column contained in the range. |
Columnsafter | workbookRangeView | Gets some columns to the right of the given range. |
Columnsbefore | workbookRangeView | Gets some columns to the left of the given range. |
Entirecolumn | Range | Gets an object that represents the entire column of the range. |
Entirerow | Range | Gets an object that represents the entire row of the range. |
Intersection | Range | Gets the range object that represents the rectangular intersection of the given ranges. |
Lastcell | Range | Gets the last cell within the range. For example, the last cell of "B2:D5" is "D5". |
Lastcolumn | Range | Gets the last column within the range. For example, the last column of "B2:D5" is "D2:D5". |
Lastrow | Range | Gets the last row within the range. For example, the last row of "B2:D5" is "B5:D5". |
Offsetrange | Range | Gets an object that represents a range that's offset from the specified range. The dimension of the returned range matches this range. If the resulting range is forced outside the bounds of the worksheet grid, an exception is thrown. |
Row | Range | Gets a row contained in the range. |
Rowsabove | workbookRangeView | Gets some rows above a given range. |
Rowsbelow | workbookRangeView | Gets some rows below a given range. |
Usedrange | Range | Returns the used range of the given range object. |
Clear | None | Clear range values, format, fill, border, etc. |
Delete | None | Deletes the cells associated with the range. |
Insert | Range | Inserts a cell or a range of cells into the worksheet in place of this range, and shifts the other cells to make space. Returns a new Range object at the now blank space. |
Merge | None | Merge the range cells into one region in the worksheet. |
Resizedrange | workbookRangeView | Gets a range object similar to the current range object, but with its bottom-right corner expanded (or contracted) by some number of rows and columns. |
Unmerge | None | Unmerge the range cells into separate cells. |
Visibleview | workbookRangeView | Get the range visible from a filtered range. |
Properties
Property | Type | Description |
---|---|---|
address | string | Represents the range reference in A1-style. Address value contains the Sheet reference (for example, Sheet1!A1:B4). Read-only. |
addressLocal | string | Represents range reference for the specified range in the language of the user. Read-only. |
cellCount | int | Number of cells in the range. Read-only. |
columnCount | int | Represents the total number of columns in the range. Read-only. |
columnHidden | boolean | Represents if all columns of the current range are hidden. |
columnIndex | int | Represents the column number of the first cell in the range. Zero-indexed. 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. |
hidden | boolean | Represents if all cells of the current range are hidden. Read-only. |
numberFormat | Json | Represents Excel's number format code for the given cell. |
rowCount | int | Returns the total number of rows in the range. Read-only. |
rowHidden | boolean | Represents if all rows of the current range are hidden. |
rowIndex | int | Returns the row number of the first cell in the range. Zero-indexed. Read-only. |
text | Json | 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. |
valueTypes | Json | Represents the type of data of each cell. The possible values are: Unknown , Empty , String , Integer , Double , Boolean , Error . Read-only. |
values | Json | Represents the raw values of the specified range. 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 |
---|---|---|
format | workbookRangeFormat | Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only. |
sort | workbookRangeSort | The worksheet containing the current range. Read-only. |
worksheet | workbookWorksheet | The worksheet containing the current range. Read-only. |
JSON representation
The following JSON representation shows the resource type.
{
"address": "string",
"addressLocal": "string",
"cellCount": 1024,
"columnCount": 1024,
"columnHidden": true,
"columnIndex": 1024,
"formulas": "json",
"formulasLocal": "json",
"formulasR1C1": "json",
"hidden": true,
"numberFormat": "json",
"rowCount": 1024,
"rowHidden": true,
"rowIndex": 1024,
"text": "json",
"valueTypes": "string",
"values": "json"
}
Feedback
https://aka.ms/ContentUserFeedback.
Bald verfügbar: Im Laufe des Jahres 2024 werden wir GitHub-Issues stufenweise als Feedbackmechanismus für Inhalte abbauen und durch ein neues Feedbacksystem ersetzen. Weitere Informationen finden Sie unterFeedback senden und anzeigen für