officer: sheet_select – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

sheet_select

select sheet

Description

set a particular sheet selected when workbook will be edited.

Usage

sheet_select(x, sheet)

Arguments

`x`	rxlsx object
`sheet`	sheet name

Examples

my_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") )

officer

Manipulation of Microsoft Word and PowerPoint Documents

v0.3.18

GPL-3

Authors

David Gohel [aut, cre], Frank Hangler [ctb] (function body_replace_all_text), Liz Sander [ctb] (several documentation fixes), Anton Victorson [ctb] (fixes xml structures), Jon Calder [ctb] (update vignettes), John Harrold [ctb] (function annotate_base), John Muschelli [ctb] (google doc compatibility)

Initial release