Skip to main content

Get Spreadsheet Row Count

Command description

Get the total number of used rows in the specified spreadsheet.

Command Input Parameters

input parametersInput parameter typeDescription
Excel ObjectExcelApp
sheetstrWorksheet name. Defaults to the active worksheet

Command Output Parameters

Output parametersOutput parameter typeDescription
Row Countint
tip

The default openpyxl mode does not require Microsoft Office or Kingsoft WPS. If you select Office or WPS when opening the spreadsheet, Runavelo uses that application to process the data.

Example

See Read Spreadsheet Displayed Data.