8.1.7.4 Datasheet::FindCol

It is recommended that you switch to the originpro package. PyOrigin is primarily for users who need to work with Origin version prior to 2021.

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples

Description

Get the number of columns in active worksheet.

Syntax

FindCol(Label, Begin = 0, Casesensitive = False, FullMatch = True, End = -1, AllowShortName = True)

Parameters

Label: string to search for column long name, also look for short name if bAllowShortName is True.
Begin: Column index (0 offset) to start searching. Its default value is 0.
CaseSensitive: True if case sensitive. Its default value is False.
FullMatch: False if only match substring, must set to True if AllowShortName is used. Its default value is True.
End: End of Column index for searching, when it is -1, search till the last of column. Its default value is -1.
AllowShortName: first check short name if True, when False, short name is ignored. Its default value is True.

Return

column

Examples

EX1

import PyOrigin
wks=PyOrigin.FindWorksheet('[Book1]Sheet1')
#Get the number of columns in active sheet
wks.Columns(0).SetLongName('Time')
wks.FindCol('Time').SetFormula('i')
wks.FindCol('Time').ExecuteFormula()