setSheetPos-methods {XLConnect} | R Documentation |
Setting worksheet position
Description
Sets the position of a worksheets in a workbook
.
Usage
## S4 method for signature 'workbook,character,numeric'
setSheetPos(object,sheet,pos)
Arguments
object |
The |
sheet |
The name of the worksheet ( |
pos |
The position index to set for the corresponding |
Details
It is important to note that the worksheet positions will be applied one after the other in the order they have been specified.
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
workbook
, getSheetPos
,
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)
# Move the 'mtcars3' worksheet to the front
setSheetPos(wb, sheet = "mtcars3", pos = 1)
## End(Not run)
[Package XLConnect version 1.0.10 Index]