Accessing Data Items

Public Function GetColIndexFromColNameOrIndex(ColNameOrIntIndex As Variant, Optional SuppressError As Boolean = True, Optional ColInterpretation As xf_ColInterpretationEnum = xf_ColInterpretation_FirstAsIndex) As Integer

Get a column index from a column index or name
- if the passed value is an integer, it is treated as a column index
- if the passed value is a string and ColInterpretation=xf_ColInterpretation_FirstAsName, it is treated as a column name always (even if it is numeric)
- if the passed value is a string and ColInterpretation=xf_ColInterpretation_FirstAsIndex , the value is treated as a column index if the string can be converted to an integer, or as a column name otherwise

Public Property Get Item(Optional ColNameOrIntIndex As Variant = -1, Optional RowIndexOrPkVal As Variant = -1, Optional SuppressError As Boolean = False) As Variant

Return the data item by column and row. The column name or index may be used. The row index or the row unique value as set up with SetupPKCache may be used.
If omitted altogether (equivalent to passing an index of -1), the current iteration row or column value is used.

Public Property Get ItemByIndex(ColIndex As Integer, RowIndex As Long, Optional SuppressError As Boolean = False) As Variant

Return the data item by column and row index. This accessor does not support column names, iteration or unique value lookup, but it is very fast.