Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Collapse]Examples
    [Expand]Files
    [Expand]Workbooks
    [Expand]Worksheets
    [Collapse]Rows and Columns
      How to: Access a Row or Column
      How to: Add a New Row or Column to a Worksheet
      How to: Delete a Row or Column from a Worksheet
      How to: Copy a Row or Column
      How to: Show or Hide a Row or Column
      How to: Freeze and Unfreeze Rows and Columns
      How to: Specify Row Height or Column Width
    [Expand]Cells
    [Expand]Formulas
    [Expand]Import and Export Data
    [Expand]Data Binding
    [Expand]Mail Merge
    [Expand]Formatting Cells
    [Expand]Conditional Formatting
    [Expand]Group Data
    [Expand]Filter Data
    [Expand]Tables
    [Expand]Pivot Tables
    [Expand]Printing
    [Expand]Pictures
    [Expand]Charts
    [Expand]Protection
    [Expand]Customization
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

How to: Delete a Row or Column from a Worksheet

Expanded Row

Show Me

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=E4655.

This example demonstrates how to delete rows from a worksheet. You can do this in one of the following ways.

  • Call the Row.Delete method of the Row object representing the row to be deleted.

  • Call the RowCollection.Remove method of the object that is accessed via the Worksheet.Rows property. Pass the zero-based index of a row to be deleted as a parameter. To delete multiple rows, pass the number of rows to be deleted as well.

  • To delete a row containing the specified cell or multiple rows containing the specified range of cells, use the Worksheet.DeleteCells method with the cell or cell range and DeleteMode.EntireRow enumeration member passed as parameters.

When you delete rows from a worksheet, other rows are automatically shifted up.

You can also hide worksheet rows. See the How to: Show or Hide a Row or Column topic for details.

Note

The number of rows in a worksheet is permanently fixed - 1,048,576.

After rows have been removed from a worksheet via the control's UI, the SpreadsheetControl.RowsRemoved event is raised.

Expanded Column

Show Me

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=E4655.

This example demonstrates how to delete columns from a worksheet. You can do this in one of the following ways.

  • Call the Column.Delete method of the Column object representing the column to be deleted.

  • Call the ColumnCollection.Remove method of the object that is accessed via the Worksheet.Columns property. Pass the zero-based index of a column to be deleted as a parameter. To delete multiple columns, pass the number of columns to be deleted as well.

  • To delete a column containing the specified cell or multiple columns containing the specified range of cells, use the Worksheet.DeleteCells method with the cell or cell range and DeleteMode.EntireColumn enumeration member passed as parameters.

When you delete columns from a worksheet, other columns are automatically shifted to the left.

You can also hide worksheet columns. See the How to: Show or Hide a Row or Column topic for details.

Note

The number of columns in a worksheet is permanently fixed - 16,384.

After columns have been removed from a worksheet via the control's UI, the SpreadsheetControl.ColumnsRemoved event is raised.

Expanded See Also

How would you rate this topic?​​​​​​​