getSheetPos-methods
From XLConnect v1.0.1
by Martin Studer
Querying worksheet position
Usage
# S4 method for workbook,character
getSheetPos(object,sheet)
Arguments
Value
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!
See Also
'>workbook
, setSheetPos
,
getSheets
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 worksheet positions for the worksheets 'mtcars2', 'mtcars3',
# 'mtcars' and 'NotThere' (which actually does not exist)
print(getSheetPos(wb, sheet = c("mtcars2", "mtcars3", "mtcars", "NotThere")))
# }
Community examples
pearlveera@gmail.com
at
Jul 2, 2018
XLConnect
v0.2-15
demoexcel <- system.file("demoFiles/mtcars.xlsx", package = XLConnect) wb <- loadWorkbook(demoexcel) print(getSheetPos(wb, sheet = "sheet1")