Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / PreviousNonEmptyColumnInRow Method
the start row index
the start column index
Return the last block index if the found cell is in block with the specified cell.


In This Topic
PreviousNonEmptyColumnInRow Method (Worksheet)
In This Topic
Find the previous non-empty data column in a row
Syntax
'Declaration
 

Public Function PreviousNonEmptyColumnInRow( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   Optional ByVal skipInsideItems As Boolean _
) As Integer
 
'Usage
 

Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim skipInsideItems As Boolean
Dim value As Integer
 
value = instance.PreviousNonEmptyColumnInRow(row, column, skipInsideItems)

Parameters

row
the start row index
column
the start column index
skipInsideItems
Return the last block index if the found cell is in block with the specified cell.

Return Value

the column index that contains data
See Also

Reference

Worksheet Class
Worksheet Members

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page