getLastColumn-methods {XLConnect} | R Documentation |
Queries the last (non-empty) column on a worksheet.
## S4 method for signature 'workbook,character' getLastColumn(object,sheet) ## S4 method for signature 'workbook,numeric' getLastColumn(object,sheet)
object |
The |
sheet |
The name or index of the sheet of which to query the last column |
Returns the (1-based) numeric index of the last non-empty column in the specified worksheet.
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
# 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 getLastColumn(wb, "mtcars") # Query the last row of the 'mtcars2' worksheet getLastColumn(wb, "mtcars2") # Query the last row of the 'mtcars3' worksheet getLastColumn(wb, "mtcars3")