This method inserts the same number of columns as the specified cell range contains.Įnclose your code in the SpreadsheetControl.BeginUpdate - SpreadsheetControl.EndUpdate method calls to suppress the SpreadsheetControl’s visual updates and improve its performance when you add numerous columns to a document. Whether using WPF, ASP. To insert empty columns to the left of the specified cell range, use the Worksheet.InsertCells method with the InsertCellsMode.EntireColumn enumeration member passed as a parameter. DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, Delphi, HTML5 or iOS & Android development.To insert empty rows above the specified cell range, use the. Call the RowCollection.Insert method of the Worksheet.Rows collection to insert a row at the specified position or add multiple rows at once.

Use the Row.Insert method to add a new row above the current row. Call the ColumnCollection.Insert method of the Worksheet.Columns collection to insert a column at the specified position or add multiple columns at once. This example demonstrates how to insert new rows into a worksheet.Use the Column.Insert method to add a new column to the left of the current column.This example demonstrates how to insert new columns into a worksheet.

New VCL-specific features/capabilities include the following: Enhanced High DPI Resolution Support. The number of rows in a worksheet is permanently fixed - 1,048,576.Īfter new rows have been inserted into a worksheet via the control’s UI, the SpreadsheetControl.RowsInserted event is raised. To review all new features and capabilities introduced in the latest release, please see What's New in VCL v23.1.

Devexpress xamarin save new row