Get the Sheet's Used Range
Retrieve the used range of an Excel sheet.
Note: This operation is part of the Excel Book (BDK). To use this book, you need to first learn it in your agent.
Input Concepts
| Concept | Description | Type | Required |
|---|---|---|---|
sheet | The reference to the Excel sheet. | excel sheet reference | Yes |
Output Concepts
| Concept | Description | Type |
|---|---|---|
sheet's used range | The used range of the sheet. | excel range reference |
Examples
Retrieve the used range of an Excel sheet.
get the first sheet
use the above as the sheet
get the sheet's used rangeUpdated 6 days ago