ss_write_sheet_columns: Write the initial columns for the a sheet

In smartsheetr: Access and Write 'Smartsheet' Data using the 'Smartsheet' API 2.0

Write the initial columns for the a sheet

Description

Write the initial columns for the a sheet

Usage

ss_write_sheet_columns(sheet_name, data = data.frame(PK = character()))

Arguments

sheet_name	A character vector
data	A data frame of columns to be added

Details

The Smartsheet API 2.0 uses two calls for creating a sheet with data. The first is a call to create a sheet and populate the columns (analogous to ss_write_sheet_columns). The second is to add rows (analogous to ss_add_rows). ss_write_sheet accomplishes both of these steps.

Value

A ss_createsheet_resp object

Examples

## Not run: 
temp_sheet_name = paste0("smartsheetr-example-",random_sheet_name())
ss_id = ss_sheetid(ss_write_sheet_columns(temp_sheet_name, data=mtcars))
ss_read_sheet(ss_id) # No rows. Use ss_write_sheet() to write the full data frame
# clean up
ss_delete_sheet(ss_id)

## End(Not run)

smartsheetr documentation built on Nov. 2, 2023, 5:42 p.m.