Click or drag to resize

IGoExcelFindRow Method

Finds and selects a row that matches the given values.

Namespace:  Autodesk.iLogic.Interfaces
Assembly:  Autodesk.iLogic.Interfaces (in Autodesk.iLogic.Interfaces.dll) Version: 23.0
Syntax
Copy
Function FindRow ( 
	fileName As String,
	sheetName As String,
	ParamArray sizeArgs As Object()
) As Integer

Parameters

fileName
Type: SystemString
The relative or absolute filename of the Excel workbook. (Relative paths are recommended.)
sheetName
Type: SystemString
The name of the worksheet.
sizeArgs
Type: SystemObject
A list of column header names, operators, and values, e.g. "Dia", "=", 0.5, "Length", "=", 2.0.

Return Value

Type: Int32
If a matching row is found, the row index is returned. If not, a value of -1 will be returned.
See Also