sbf_save_excel: Save Dataframe to Excel Workbook

In poissonconsulting/subfoldr2: Save and Load R Objects

Save Dataframe to Excel Workbook

Description

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

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.

Value

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

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

## Not run: 
sbf_save_excel()

## End(Not run)

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