createWorkbook: Create a new Workbook object

Description Usage Arguments Value Author(s) See Also Examples

Description

Create a new Workbook object

Usage

1
2
3
createWorkbook(creator = ifelse(.Platform$OS.type == "windows",
  Sys.getenv("USERNAME"), Sys.getenv("USER")), title = NULL, subject = NULL,
  category = NULL)

Arguments

creator

Creator of the workbook (your name). Defaults to login username

title

Workbook properties title

subject

Workbook properties subject

category

Workbook properties category

Value

Workbook object

Author(s)

Alexander Walker

See Also

loadWorkbook

saveWorkbook

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
## Create a new workbook
wb <- createWorkbook()

## Save workbook to working directory
saveWorkbook(wb, file = "createWorkbookExample.xlsx", overwrite = TRUE)

## Set Workbook properties
wb <- createWorkbook(creator = "Me"
, title = "title here"
, subject = "this & that"
, category = "something")

awalker89/openxlsx documentation built on May 11, 2019, 4:09 p.m.