Finds and selects a row that matches the given values.
Namespace: Autodesk.iLogic.Interfaces
Assembly: Autodesk.iLogic.Interfaces (in Autodesk.iLogic.Interfaces.dll) Version: 29.0
Syntax
VB
Function FindRow ( fileName As String, sheetName As String, ParamArray sizeArgs As Object() ) As Integer
C#
int FindRow( string fileName, string sheetName, params Object[] sizeArgs )
Parameters
- fileName
- Type: System.String
The relative or absolute filename of the Excel workbook. (Relative paths are recommended.) - sheetName
- Type: System.String
The name of the worksheet. - sizeArgs
- Type: System.Object[]
A list of column header names, operators, and values, e.g. "Dia", "=", 0.5, "Length", "=", 2.0.
Return Value
Type: Int32If a matching row is found, the row index is returned. If not, a value of -1 will be returned.