Skip to main content

Get Spreadsheet Column Count

Command description​

Get the total number of used columns 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
Column 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.