createWorkbook: Create a new Workbook object

In openxlsx: Read, Write and Edit xlsx Files

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

Author(s)

Alexander Walker

See Also

loadWorkbook

saveWorkbook

Examples

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

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

## End(Not run)

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

Example output

Note: zip::zip() is deprecated, please use zip::zipr() instead
Warning message:
Workbook does not contain any worksheets. A worksheet will be added. 

openxlsx documentation built on June 16, 2021, 9:06 a.m.