Save Dataframe to Excel Workbook

Usage

sbf_save_excel(
  x,
  x_name = substitute(x),
  max_sheets = 1L,
  sub = sbf_get_sub(),
  main = sbf_get_main(),
  epgs = NULL
)

Arguments

x: The data frame to save.
x_name: A string of the name.
max_sheets: An integer specifying the maximum number of sheets to split your table into for writing to excel. The default is 1.
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

Value

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

Details

This takes a data frame and saves it to their own excel workbook.

This function will split up large dataframes into smaller tables for writing to excel because excel only allows a maximum number of 1,048,576. For the max_sheets argument you can pass a number higher then the required and it will only return as many sheets as there is data.

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_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()

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

Examples

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