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 |
| 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 |
| Theme | ||
| 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 |