Click or drag to resize

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
)

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