Setting worksheet position — setSheetPos-methods • XLConnect

Sets the position of a worksheets in a workbook.

# S4 method for class 'workbook,character,numeric'
setSheetPos(object,sheet,pos)

Arguments

object: The workbook to use
sheet: The name of the worksheet (character) whose position to set. This argument is vectorized such that the positions of multiple worksheets can be set with one method call.
pos: The position index to set for the corresponding sheet. If missing, sheets will be positioned in the order they are specified in the argument sheet.

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

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

See also

workbook, getSheetPos, getSheets

Examples

if (FALSE) { # \dontrun{
# 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)
} # }