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

Share:

Description

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

Usage

1
2
3
4
## S4 method for signature 'workbook,character'
getLastColumn(object,sheet)
## S4 method for signature 'workbook,numeric'
getLastColumn(object,sheet)

Arguments

object

The workbook to use

sheet

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

Details

Returns the (1-based) numeric index of the last non-empty column in the specified worksheet.

Author(s)

Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com

See Also

workbook

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
# 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")

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.