Querying the last (non-empty) row on a worksheet

Queries the last (non-empty) row on a worksheet.

# S4 method for class 'workbook,character'
getLastRow(object,sheet)
# S4 method for class 'workbook,numeric'
getLastRow(object,sheet)

Arguments

object

The workbook to use

sheet

The name or index of the sheet of which to query the last row

Details

Returns the numeric index of the last non-empty row in the specified worksheet.

Author

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

See also

workbook

Examples

if (FALSE) { # \dontrun{
# mtcars xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")

# Load workbook
wb <- loadWorkbook(demoExcelFile)

# Query the last row of the 'mtcars' worksheet
getLastRow(wb, "mtcars")

# Query the last row of the 'mtcars2' worksheet
getLastRow(wb, "mtcars2")

# Query the last row of the 'mtcars3' worksheet
getLastRow(wb, "mtcars3")
} # }