Save Database to Excel Workbook

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

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
)

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.

sub

A string 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

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_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(exclude_tables = "sites")

# exclude the sites and species table
sbf_save_db_to_workbook(exclude_tables = "sites|species")
} # }