set_columnwrites columns to the spreadsheet: for columns that already exist,
set_columnreplaces the data in the spreadsheet with the version updated using the script. For instance, if you were to retrieve the “trial” column from a spreadsheet and then make some changes, you would use
set_columnto write those changes to the spreadsheet, replacing the old data with your new data.
If the column does not already exist in the spreadsheet (for instance, if you create a new column using
set_columnwill instead create a new column in the spreadsheet.
Parameter Type Description
String (optional) Name of the column that you are inserting
Ruby container of the column that you are inserting into the spreadsheet (modified output of
You must specify a value for the
columnparameter. If you are also passing a value for the
nameparameter, the order of arguments must be
The following example retrieves the Datavyu column “trial” and assigns it to a Ruby variable called
trial. After some modifications to the trial object, it writes those changes back to the spreadsheet using
require 'Datavyu_API.rb' begin trial = getColumn("trial") <some modifications to trial> set_column("trial", trial) end