Save Dataframes to Excel Workbook

This takes the data frames from the environment and saves them to a single excel workbook where each table is its own spreadsheet.

Usage

sbf_save_workbook(
  workbook_name = basename(getwd()),
  sub = sbf_get_sub(),
  main = sbf_get_main(),
  env = parent.frame(),
  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.

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)

env

An environment.

epgs

The projection to convert to

x_name

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

Value

An invisible string of the path to the saved data.frame

See also

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

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_db_to_workbook(), 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()

Examples

if (FALSE) { # \dontrun{
sbf_save_workbook()
} # }