saveAsWorksheet {OpenRepGrid} | R Documentation |
Add grids as sheets to an openxlsx Workbook
Description
saveAsWorksheet
will add one or more grids to an a openxlsx
Workbook
object.
Usage
saveAsWorksheet(x, wb, format = "wide", sheet = NULL, default_sheet = "grid")
Arguments
x |
A |
wb |
A openxlsx |
format |
Two output formats are supported: |
sheet |
Vector of sheet names with same length as |
default_sheet |
Default sheet name to use if not supplied in |
Value
Invisibly returns Workbook object.
See Also
Examples
library(openxlsx)
wb <- createWorkbook()
# add grid to worksheet
saveAsWorksheet(boeker, wb, sheet = "boeker")
# add several grids with explicit sheet names
l <- list(bell2010, feixas2004)
saveAsWorksheet(l, wb, sheet = c("Bell 2010", "Feixas 2004"))
# list names are used as sheet names. Without name, the default applies.
l <- list(boeker, "Fransella et al. 2003" = fbb2003)
saveAsWorksheet(l, wb)
# save as Excel file
file <- tempfile(fileext = ".xlsx")
saveWorkbook(wb, file)
## Not run:
browseURL(file) # may not work on all systems
## End(Not run)