Learn R Programming

openxlsx (version 4.2.3)

createWorkbook: Create a new Workbook object

Description

Create a new Workbook object

Usage

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

Examples

Run this code
# NOT RUN {
## Create a new workbook
wb <- createWorkbook()

## Save workbook to working directory
# }
# NOT RUN {
saveWorkbook(wb, file = "createWorkbookExample.xlsx", overwrite = TRUE)
# }
# NOT RUN {
## Set Workbook properties
wb <- createWorkbook(
  creator = "Me",
  title = "title here",
  subject = "this & that",
  category = "something"
)
# }

Run the code above in your browser using DataLab