# 2.2.4.5 Column

Column

## Remark

The Column class provides methods and properties common to Origin worksheet columns. An Origin C Worksheet object has a collection of Column objects each of which in turn holds a Dataset. A Column object is primarily used for style related control of the data in the associated Dataset.

An Origin C Column object is a wrapper object that is a reference to an internal Origin column object. Wrapper objects do not actually exist in Origin and merely refer to the internal Origin object. Consequently, multiple Origin C wrapper objects can refer to the same internal Origin object.

The Column class is derived from the DataObject, DataObjectBase, and OriginObject classes from which it inherits methods and properties.

## Examples

EX1

void Column_Ex1()
{
Worksheet wks = Project.ActiveLayer();
if(!wks)
return;
int ii = 1;
foreach(Column cc in wks.Columns)
{
string strLabel;
if(cc.GetLabel(strLabel) > 0)
printf("Column(%d) has label = %s\n",ii++, strLabel);
}
}

origin.h

## Members

Name Brief Example
Attach Attach the column object to a Worksheet column by worksheet name nad column number. Examples
Column Default constructor for Column class. Examples
CopyDataFormat Copy column format from source. Examples
DisableFilter Enable/Disable the filter Examples
GetAdditionalInfo Get storage information from SPC. Examples
GetCondFmtIndecies Get indexes of conditional formatted rows Examples
GetCustomDisplay Return the custom date display string. Only valid for Date type columns. Examples
GetDataObject Get the Dataset associated with a column as a vectorbase class reference. Examples
GetDigitMode Gets the display mode used for numbers in a column. Examples
GetDigits Get the digit value for numeric display mode. Examples
GetDistinctValues Get all the unique text entries of the column value. Examples
GetExtendedLabel Gets the extended label by type of extended label. Examples
GetFilter Get data filter of one column. Examples
GetFormat Get the column format. Examples
GetCategoricalMap Get the column CategoricalMap. Examples
GetInternalData Get the column internal data type. Examples
GetJustify Get the column justification. Examples
GetLabel Get the column label by reference. Examples
GetLastDependentColumnOffset Get the index of the column in the same worksheet that is farthest away. from this column and that is dependent on this column. Examples
GetLongName Get the long name of a column. Examples
GetLowerBound Get the begining row index for this column. Index values are 0 - offset. Examples
GetName Get the column short name. Examples
GetNumRows Get the number of rows in a Column. Examples
GetParameter Get one parameter value.from column label. Examples
GetParameters Gets the Parameters in a column label. Examples
GetStringArray Get the contents (from row nRow1 to nRow2) from a Column regardless of its data type. Examples
GetSubFormat Get the SubFormat used by a column. Examples
GetTextMaxLen Get the text width of a column. Examples
GetType Get the type designator of a column (X, Y, Z, YErr, XErr, L or disregard). Examples
GetUnits Get the units in a column label. Examples
GetUpperBound Get the ending row index for this column. Index values are 0 - offset. Examples
GetWidth Get the display width of a column in number of characters. Examples
IsAsCategorical Return if the column is set as categorical. Examples
IsEvenSampling Check if the column has even sampling and get the sampling information. Examples
IsFilterDisabled Gets the filter's enable status Examples
IsWriteProtected Determine if a column is write protected. Examples
PutStringArray Put (copy) the contents of a StringArray to a Column starting in row nRow1. Examples
Reverse This function is use to reverse a range of rows within a column. Examples
ResetFilter Reset data filter of one column. Examples
SetAsCategorical Set the column as categorical. Examples
SetCustomDisplay To set the custom date display format. This action is same as setup Custom Date Formats in Tools : Options : Miscellaneous. Examples
SetDigitMode Sets the display mode used for numbers in a column. Examples
SetDigits Set the digit value for the numeric display mode. Examples
SetEvenSampling Set the column sampling information. Examples
SetExtendedLabel Sets the extended label by type of extended label. Examples
SetFilter Add data filter to column. Examples
SetFilterThisCol Set variable to represent this column in filter command Examples
SetFormat Set the column format. Examples
SetInternalData Set the column internal data type. Examples
SetJustify Set the column justification. Examples
SetLabel Set the column label. Examples
SetLongName Sets the long name of a column. Examples
SetLowerBound Set the begining row display index. Examples
SetNumRows Set the number of rows in a Column. Examples
SetParameter Sets one parameter in a column label Examples
SetParameters Sets the Parameters in a column label. Examples
SetSubFormat Set the SubFormat used by a column. Examples
SetTextMaxLen Set the text width of the column. Examples
SetType Set the type designator of a column (X, Y, Z, YErr, XErr, L or disregard). Examples
SetUnits Set the units in a column label. Examples
SetUpperBound Set the ending row display index. Examples
SetWidth Set the display column width of a column in number of characters. Examples