XlsWorksheet
InsertRange Method
|
Insert a cell range into worksheet
Namespace:
Spire.Xls.Core.Spreadsheet
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public IXLSRange InsertRange(
int rowIndex,
int columnIndex,
int rowCount,
int columnCount,
InsertMoveOption moveOptions,
InsertOptionsType insertOptions
)
Public Function InsertRange (
rowIndex As Integer,
columnIndex As Integer,
rowCount As Integer,
columnCount As Integer,
moveOptions As InsertMoveOption,
insertOptions As InsertOptionsType
) As IXLSRange
public:
IXLSRange^ InsertRange(
int rowIndex,
int columnIndex,
int rowCount,
int columnCount,
InsertMoveOption moveOptions,
InsertOptionsType insertOptions
)
member InsertRange :
rowIndex : int *
columnIndex : int *
rowCount : int *
columnCount : int *
moveOptions : InsertMoveOption *
insertOptions : InsertOptionsType -> IXLSRange
Parameters
-
rowIndex
-
Type:
System
Int32
the cell range first row index
-
columnIndex
-
Type:
System
Int32
the cell range first column index
-
rowCount
-
Type:
System
Int32
the number of rows
-
columnCount
-
Type:
System
Int32
the number of columns
-
moveOptions
-
Type:
Spire.Xls
InsertMoveOption
Insert options.
-
insertOptions
-
Type:
Spire.Xls
InsertOptionsType
Move the cell on the right to right or Move the cell below down
Return Value
Type:
IXLSRange
return the range that insert into worksheet
See Also