2.5 Column


A Column is a DataObject in a Worksheet. A worksheet is a table with rows and columns. Unlike spreadsheet like Excel, Origin structures data in a sheet(table) with additional internal structure in the form of column objects, so that each column can act as separate object with additional attributes assigned to them. Also, direct access to data in a column in Origin is faster then using a range in a sheet, which is typically done in Excel.



Name Brief Example
Activate Make current column as active in current worksheet VB
Destroy Remove this column from current project and destory it VBA
Execute Run LabTalk script in the context of the object, so that the script can assume the object is the active object. This is applicable to Layer and Page objects only. VBA
GetBinaryStorageData Get value stored by SetBinaryStorageData with specified name VBA
GetData Get a range of values or a single value from a worksheet column. VB, C#
GetInfo Get column information. This function is out of date. VBA
GetMetaData Get information tree of an Origin object with an xmlDocument structure VBA, C#, VC++
SetBinaryStorageData Store an value in Origin object with specified name VB
SetData Put an array of values to a column object. VB, C#
SetEvenSampling Set sampling settings of one column VBA, C#
SetMetaData Update information of an Origin object which can be showed from Show Organizer command in context menu VBA, VB

, C# , VC++


Name Brief Example
Application Refer to the current Origin instance VB
BinaryStorageNames The collection of names of all the binarystorage in this object VB
Comments Set and get the comments of a Worksheet Column object. VBA
DataFormat Setting and getting a column's data format type to one of the supported COLDATAFORMAT types. Setting a column's data format will erase any data in the column unlike the similar action performed from Origin's Column Property dialog. VBA, C#
DigitMode Current mode to set significant digits VB
Digits Number of digit in the decimal part VB
DisplayFormat An integer value indicate current display format of the dataobject VB
EvenSampling Sample rate of the column VBA, C#

Index Indicate the position of this object in current container VB
LongName The long name of this origin object VBA, C#
Name Name of the Origin object VBA, C#
Parameter Paramters stored in a column VB
Parent The object that has this collection VB
Rows The Rows property is an integer value that holds the number of rows in the column. VB
Show Set an Origin object's visible status VB
Type Column destination type sunch as X, Y, Z VBA, C#
Units The Units as part of column property VBA, C#
UserDefLabel User-Defined label string access in a column. To show user-defined labels in worksheet, you need to first enable them for each, using wks.Labels. VBA, LabVIEW