ExcelGetBasedIndexPosition Method
Calculate position based on column/row index from offset
'Declaration
Function ExcelGetBasedIndexPosition( _
ByVal As Short, _
ByVal As Integer, _
ByVal As Integer, _
ByVal As Boolean _
) As Double
'Usage
Dim instance As IExcelXml2
Dim sheet As Short
Dim index As Integer
Dim offsetIndex As Integer
Dim isRowOffset As Boolean
Dim value As Double
value = instance.ExcelGetBasedIndexPosition(sheet, index, offsetIndex, isRowOffset)
Parameters
- sheet
- sheet index specifies a sheetView in sheetViews collection
- index
- Row or column index
- offsetIndex
- Offset value that measured in pixel
- isRowOffset
- A bool value specifies whether it is for row index
Return Value
A double value represents for a index based position