getSheetPos-methods {XLConnect} | R Documentation |
Queries the position of a worksheet in a workbook
.
## S4 method for signature 'workbook,character' getSheetPos(object,sheet)
object |
The |
sheet |
The name of the worksheet ( |
Returns the position index of the corresponding worksheet. Note that querying a non-existing worksheet results in a 0 index and does not throw an exception!
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, setSheetPos
,
getSheets
# mtcars xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect") # Load workbook wb <- loadWorkbook(demoExcelFile) # Query worksheet positions for the worksheets 'mtcars2', 'mtcars3', # 'mtcars' and 'NotThere' (which actually does not exist) print(getSheetPos(wb, sheet = c("mtcars2", "mtcars3", "mtcars", "NotThere")))