smartsheetr (version 0.1.0)

ss_write_sheet_columns: 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()))

Value

A ss_createsheet_resp object

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.

Examples

if (FALSE) {
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)
}