officefileapi-devexpress-dot-spreadsheet-dot-worksheet-dot-insertcells-x28-devexpress-dot-spreadsheet-dot-cellrange-devexpress-dot-spreadsheet-dot-insertcellsmode-x29.md
Inserts new cells in the worksheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void InsertCells(
CellRange range,
InsertCellsMode mode
)
Sub InsertCells(
range As CellRange,
mode As InsertCellsMode
)
| Name | Type | Description |
|---|---|---|
| range | CellRange |
A CellRange object specifying a cell range where new cells should be inserted.
| | mode | InsertCellsMode |
An InsertCellsMode enumeration member specifying in which direction to shift other cells.
|
Use the InsertCells method to insert new cells at the position of the specified cell range.
You can insert a new range and shift other cells in the same column down, or shift other cells in the same row to the right. You can also insert empty rows and columns above or to the left of the specified range of cells, respectively (the same number of rows or columns that comprise the specified range).
To delete cells, use the Worksheet.DeleteCells method (see the How to: Delete a Cell or Range of Cells example).
Another way to insert and delete the cell range is to use the range’s RangeExtensions.Insert and RangeExtensions.Delete extension methods, defined by the RangeExtensions class. These extension methods are accessible as methods of the CellRange object and called by using the instance method syntax.
This example demonstrates how to insert cells into a worksheet. To do this, use the Worksheet.InsertCells method. Pass a cell or cell range where you want to insert new cells, and the InsertCellsMode.ShiftCellsDown or InsertCellsMode.ShiftCellsRight enumeration member to specify how to shift other cells.
using DevExpress.Spreadsheet;
// ...
IWorkbook workbook = spreadsheetControl1.Document;
Worksheet worksheet = workbook.Worksheets[0];
// Insert a cell into the C5 position, shifting other cells in the same column down.
worksheet.InsertCells(worksheet.Cells["C5"], InsertCellsMode.ShiftCellsDown);
// Insert cells into the location of the H11:I12 range, shifting other cells in the same row to the right.
worksheet.InsertCells(worksheet.Range["H11:I12"], InsertCellsMode.ShiftCellsRight);
Imports DevExpress.Spreadsheet
' ...
Dim workbook As IWorkbook = spreadsheetControl1.Document
Dim worksheet As Worksheet = workbook.Worksheets(0)
' Insert a cell into the C5 position, shifting other cells in the same column down.
worksheet.InsertCells(worksheet.Cells("C5"), InsertCellsMode.ShiftCellsDown)
' Insert cells into the location of the H11:I12 range, shifting other cells in the same row to the right.
worksheet.InsertCells(worksheet.Range("H11:I12"), InsertCellsMode.ShiftCellsRight)
The following code snippets (auto-collected from DevExpress Examples) contain references to the InsertCells(CellRange, InsertCellsMode) method.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
// Insert two rows above the "L15:M16" cell range.
worksheet.InsertCells(worksheet.Range["L15:M16"], InsertCellsMode.EntireRow);
#endregion #InsertRows
// Insert two rows above the "L15:M16" cell range.
worksheet.InsertCells(worksheet.Range["L15:M16"], InsertCellsMode.EntireRow);
#endregion #InsertRows
// Insert two rows above the "L15:M16" cell range.
worksheet.InsertCells(worksheet.Range["L15:M16"], InsertCellsMode.EntireRow);
#endregion #InsertRows
' Insert two rows above the "L15:M16" cell range.
worksheet.InsertCells(worksheet.Range("L15:M16"), InsertCellsMode.EntireRow)
' #End Region ' #InsertRows
' Insert two rows above the "L15:M16" cell range.
worksheet.InsertCells(worksheet.Range("L15:M16"), InsertCellsMode.EntireRow)
' #End Region ' #InsertRows
' Insert two rows above the "L15:M16" cell range.
worksheet.InsertCells(worksheet.Range("L15:M16"), InsertCellsMode.EntireRow)
#End Region ' #InsertRows
See Also