sbf_save_db_to_workbook: Save Database to Excel Workbook

In poissonconsulting/subfoldr2: Save and Load R Objects

Save Database to Excel Workbook

Description

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
)

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

## Not run: 
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")

## End(Not run)

poissonconsulting/subfoldr2 documentation built on Nov. 17, 2024, 1:33 a.m.