getLastRow-methods {XLConnect} | R Documentation |
Querying the last (non-empty) row on a worksheet
Description
Queries the last (non-empty) row on a worksheet.
Usage
## S4 method for signature 'workbook,character'
getLastRow(object,sheet)
## S4 method for signature 'workbook,numeric'
getLastRow(object,sheet)
Arguments
object |
The |
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(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
Examples
## Not run:
# 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")
## End(Not run)
[Package XLConnect version 1.0.10 Index]