officefileapi-devexpress-dot-spreadsheet-dot-column-07104b35.md
Inserts a new column into the worksheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void Insert()
Sub Insert
Use the Insert method to add a new column to the left of the current column. To add more than one column, use the ColumnCollection.Insert method.
Note
The number of columns in a worksheet is unchanged - 16,384. When you add new columns, the equivalent number of columns at the end are automatically removed from the worksheet.
To copy data (for example, values, formulas, formatting, etc.) from one column to another one, use the CellRange.CopyFrom method. For details, see the How to: Copy a Row or Column example.
This example demonstrates how to insert new columns into a worksheet.
Column.Insert method to add a new column to the left of the current column.Enclose your code in the Workbook.BeginUpdate - Workbook.EndUpdate method calls to improve performance when you add multiple columns to a document.
// Insert a new column C.
worksheet.Columns["C"].Insert();
// Insert a new column into the worksheet at the 5th position.
worksheet.Columns.Insert(4);
// Insert three columns into the worksheet at the 7th position.
worksheet.Columns.Insert(6, 3);
// Insert two columns to the left of the "L15:M16" cell range.
worksheet.InsertCells(worksheet.Range["L15:M16"], InsertCellsMode.EntireColumn);
' Insert a new column C.
worksheet.Columns("C").Insert()
' Insert a new column into the worksheet at the 5th position.
worksheet.Columns.Insert(4)
' Insert three columns into the worksheet at the 7th position.
worksheet.Columns.Insert(6, 3)
' Insert two columns to the left of the "L15:M16" cell range.
worksheet.InsertCells(worksheet.Range("L15:M16"), InsertCellsMode.EntireColumn)
The following code snippets (auto-collected from DevExpress Examples) contain references to the Insert() 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 a new column C.
worksheet.Columns["C"].Insert();
// Insert a new column C.
worksheet.Columns["C"].Insert();
// Insert column "C".
worksheet.Columns["C"].Insert();
' Insert a new column C.
worksheet.Columns("C").Insert()
' Insert a new column C.
worksheet.Columns("C").Insert()
' Insert column "C".
worksheet.Columns("C").Insert()
' Insert column "E".
See Also