Skip to contents

Write RCDF data to Excel files

Source: R/write_rcdf_as.R
write_rcdf_xlsx.Rd

Writes each table in the RCDF object as a separate .xlsx file using the openxlsx package.

Usage

write_rcdf_xlsx(data, path, ..., parent_dir = NULL)

Arguments

data

A valid RCDF object.

path

The output directory.

...

Additional arguments passed to openxlsx::write.xlsx().

parent_dir

Optional subdirectory under path to group Excel files.

Value

Invisibly returns NULL. Files are written to disk.

See also

write_rcdf_as

Examples

dir <- system.file("extdata", package = "rcdf")
rcdf_path <- file.path(dir, 'mtcars.rcdf')
private_key <- file.path(dir, 'sample-private-key.pem')

rcdf_data <- read_rcdf(path = rcdf_path, decryption_key = private_key)
#> Error in check_dbplyr(): The package "dbplyr" is required to communicate with database backends.
temp_dir <- tempdir()

write_rcdf_xlsx(data = rcdf_data, path = temp_dir)
#> Error: object 'rcdf_data' not found

unlink(temp_dir, force = TRUE)