transfer_columns(db1, db2, remove, *varnames)¶
Transfers columns between spreadsheets. Replacing
db2with the empty string “”, will refer instead to the currently open spreadsheet in Datavyu.
Thus, if you want to transfer a column into the GUI, set
db2to ‘’, and specify the origin spreadsheet file as
db1. If you want to transfer a column from the GUI into a file, set
db1to ‘’, and set
db2to that file’s path.
TRUEwill DELETE THE COLUMNS YOU ARE TRANSFERRING FROM DB1.
The full path to save the first Datavyu file. Set to ‘’ to use the spreadsheet that’s currently open.
The full path to save the second Datavyu file. Set to ‘’ to use the spreadsheet that’s currently open.
TRUE, Datavyu will delete the columns from
db1as they are copied to
FALSEleaves the columns intact.
list of strings
List of the names of the columns that you wish to copy from
db1. You must specify at least one column name.
Nothing. Saves files in place or modifies the GUI.
The following example transfers the column “idchange” from test.opf to the GUI and leaves test.opf intact and unmodified.
require 'Datavyu_API.rb' begin sourceFile='/Users/datavyutester/Desktop/FileName1.opf' destinationFile='/Users/datavyutester/Desktop/FileName2.opf' columnsToTransfer = ['trial_rel', 'condition_rel'] transferMyVariable(sourceFile, destinationFile, false, columnsToTransfer) end