Skip to contents

Save Database to Excel Workbook

sbf_save_db_to_workbook.Rd

Converts a database to an single excel workbook where each table is its own spreadsheet.

Usage

sbf_save_db_to_workbook(
  workbook_name = sbf_get_workbook_name(),
  db_name = sbf_get_db_name(),
  exclude_tables = "^$",
  sub = sbf_get_sub(),
  main = sbf_get_main(),
  epgs = NULL,
  x_name = ".*"
)

Arguments

workbook_name

The name of the excel workbook you are creating. Default is the base name of the current working directory.

db_name

A string of the database name.

exclude_tables

A regular expression listing tables to be excluded. Currently soft-deprecated. Use x_name instead.

sub

A string or character vector specifying the path to the sub folder (by default the current sub folder).

main

A string specifying the path to the main folder (by default the current main folder)

epgs

The projection to convert to

x_name

A string of the Perl-compatible regular expression to match.

See also

Other excel: sbf_get_workbook_name(), sbf_save_excel(), sbf_save_excels(), sbf_save_workbook()

Other save functions: sbf_basename_sans_ext(), sbf_save_aws_files(), sbf_save_block(), sbf_save_data(), sbf_save_data_to_db(), sbf_save_data_to_pg(), sbf_save_datas(), sbf_save_datas_to_db(), sbf_save_db_metatable_descriptions(), sbf_save_excel(), sbf_save_excels(), sbf_save_gpkg(), sbf_save_gpkgs(), sbf_save_number(), sbf_save_numbers(), sbf_save_object(), sbf_save_objects(), sbf_save_plot(), sbf_save_png(), sbf_save_spatial(), sbf_save_spatials(), sbf_save_string(), sbf_save_strings(), sbf_save_table(), sbf_save_window(), sbf_save_workbook()

Examples

if (FALSE) { # \dontrun{
sbf_save_db_to_workbook()

# exclude the sites table
sbf_save_db_to_workbook(x_name = "^(?!sites$)")

# exclude the sites and species table
sbf_save_db_to_workbook(x_name = "^(?!(sites|species)$)")
} # }