Select sheet
Set a particular sheet selected when workbook will be edited.
sheet_select(x, sheet)
x
: rxlsx objectsheet
: sheet namemy_ws <- read_xlsx() my_pres <- add_sheet(my_ws, label = "new sheet") my_pres <- sheet_select(my_ws, sheet = "new sheet") print(my_ws, target = tempfile(fileext = ".xlsx") )
Useful links