Get the Row Count in a Worksheet Range

Get the number of rows in 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

ConceptDescriptionTypeRequired
worksheet rangeThe reference to the Excel range.excel range referenceYes

Output Concepts

ConceptDescriptionType
row countThe number of rows in the sheet range.number

Examples

Get the number of rows in an Excel sheet.

get the sheet's used range
use the above as the range
get row count in the range