as_xlsx_file {rolap}

Generate a xlsx file with fact and dimension tables

Description

To port databases to other work environments it is useful to be able to export them as a xlsx file, as this function does.

Usage

as_xlsx_file(db, file)

## S3 method for class 'star_database'
as_xlsx_file(db, file = NULL)

Arguments

db

A star_database object.

file

A string, name of a file.

Value

A string, name of a file.

See Also

star_database

Other star database exportation functions: as_csv_files(), as_dm_class(), as_multistar(), as_rdb(), as_single_tibble_list(), as_tibble_list(), draw_tables()

Examples

db1 <- star_database(mrs_cause_schema, ft_num) |>
  snake_case()
tl1 <- db1 |>
  as_xlsx_file()

db2 <- star_database(mrs_age_schema, ft_age) |>
  snake_case()

ct <- constellation("MRS", db1, db2)
f <- ct |>
  as_xlsx_file(file = tempfile())