LocateInColumn Method

Important note
Applies to a design table sheet. Returns the index of the first row which contains a specified value. Returns zero if the value is not found or if the method arguments are not properly specified.

Syntax

sheet.LocateInColumn(columnIndex: Integer, value: Literal) : Integer

The LocateInColumn method has two arguments:

Arguments	Description
ColumnNumber	Required. Number or index of the table column. Integer from 1 to n.
Value	Required. Value searched for. Can be a string or a boolean

Example

Line=Relations\DesignTable1\sheet_name.LocateInColumn(4,11mm)
if (Line == 0)
{
Message("No value found !!!")
}

Sample

KwrProgramDT.CATPart