Create a new Workbook object — createWorkbook • openxlsx

Create a new Workbook object

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

See also

loadWorkbook()

saveWorkbook()

Author

Alexander Walker

Examples

## Create a new workbook
wb <- createWorkbook()

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

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