Learn R Programming

smartsheetr (version 0.1.0)

ss_delete_columns: Delete non-primary columns from a given sheet.

Description

The primary column(s) cannot be deleted.

Usage

ss_delete_columns(ss_id, column_ids = NULL)

Value

A list of ss_resp objects

Arguments

ss_id

The sheetId, permalink, or name of the Smartsheet sheet to read

column_ids

A vector of the smartsheet rowIds, or NULL to delete all non-primary columns

Examples

Run this code
if (FALSE) {
df = data.frame(PK=c(1,2), FK=c("a","b"))
ss_id = ss_sheetid(ss_write_sheet(paste0("smartsheetr-example-",random_sheet_name()), data=df))
col_ids = ss_column_ids(ss_id)
ss_delete_columns(ss_id, col_ids[2])
ss_read_sheet(ss_id)
# clean up
ss_delete_sheet(ss_id)
}

Run the code above in your browser using DataLab