FillRange(Int32,Int32,Int32,Int32,Int32,FillDirection,Boolean,Boolean) Method
In This Topic
Fills a range of cells on this sheet by copying a specified range in the specified direction.
Syntax
'Declaration
Public Overloads Sub FillRange( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As Integer, _
ByVal As FillDirection, _
ByVal As Boolean, _
ByVal As Boolean _
)
'Usage
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim fillCount As Integer
Dim fillDirection As FillDirection
Dim dataOnly As Boolean
Dim valuesOnly As Boolean
instance.FillRange(row, column, rowCount, columnCount, fillCount, fillDirection, dataOnly, valuesOnly)
Parameters
- row
- Row index of the starting cell in the range to copy
- column
- Column index of the starting cell in the range to copy
- rowCount
- Number of rows in the range to copy
- columnCount
- Number of columns in the range to copy
- fillCount
- Number of rows or columns into which to copy the specified range
- fillDirection
- Direction of fill (to copy the specified range)
- dataOnly
- Whether to fill data only (or also styles and spans)
- valuesOnly
- Whether to fill in values only (or also formulas, notes, and tags)
Exceptions
See Also