Save Dataframe to Excel Workbook

Save Dataframe to Excel Workbook

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.

See also

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()
} # }