setSheetPos-methods {XLConnect} | R Documentation |
Sets the position of a worksheets in a workbook
.
## S4 method for signature 'workbook,character,numeric' setSheetPos(object,sheet,pos)
object |
The |
sheet |
The name of the worksheet ( |
pos |
The position index to set for the corresponding |
It is important to note that the worksheet positions will be applied one after the other in the order they have been specified.
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, getSheetPos
,
getSheets
# mtcars xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect") # Load workbook wb <- loadWorkbook(demoExcelFile) # Move the 'mtcars3' worksheet to the front setSheetPos(wb, sheet = "mtcars3", pos = 1)