replace_sheet_with_csv: Replace an existing Smartsheet with a new file

In elias-jhsph/rsmartsheet: R SDK For Smartsheet

Replace an existing Smartsheet with a new file

Description

Replaces the data in all existing rows and then adds new rows as appropriate. Throws errors if the same columns are not present in both the the Sheet and csv to repalce it.

Usage

replace_sheet_with_csv(
  sheet_name,
  file_path,
  never_delete = FALSE,
  batch_size = 5000
)

Arguments

sheet_name	the target Smartsheet's exact sheet name
file_path	the path to the file that will overwrite the existing attachment
never_delete	prevents deleting extra rows if the replacement csv has fewer rows than target sheet

Value

returns nothing

Examples

## Not run: 
replace_sheet_with_csv("sheet_name","a_folder/maybe_another_folder/sheet.csv")

## End(Not run)

elias-jhsph/rsmartsheet documentation built on April 27, 2024, 3:14 p.m.