openxlsx (version 2.0.1)

addWorksheet: Add a worksheet to a workbook

Description

Add a worksheet to a workbook

Usage

addWorksheet(wb, sheetName, gridLines = TRUE)

Arguments

wb

A Workbook object to attach the new worksheet

sheetName

A name for the new worksheet

gridLines

A logical. If FALSE, the worksheet grid lines will be hidden.

Value

• XML tree

Examples

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

## Add 3 worksheets
addWorksheet(wb, "Worksheet Name")
addWorksheet(wb, "This is worksheet 2")
addWorksheet(wb, "The third worksheet")

## Save workbook
saveWorkbook(wb, "addWorksheetExample.xlsx", overwrite = TRUE)