Spread Windows Forms 13.0 Product Documentation
Spread Windows Forms 13.0 Product Documentation / Developer's Guide / Understanding the Spreadsheet Objects / Working with Rows and Columns / Removing a Row or Column
In This Topic
    Removing a Row or Column
    In This Topic

    You can remove one or more columns or rows from a sheet. You can use the methods in the SheetView class.

    For more details refer to the SheetView.RemoveRows method or SheetView.RemoveColumns method.

    If you simply want to hide the row or column from the end user, but not remove it from the sheet, refer to Showing or Hiding a Row or Column.

    Using a Shortcut

    Example

    This example code removes two columns before column 6.

    C#
    Copy Code
    fpSpread1.Sheets[0].RemoveColumns(6,2);
    VB
    Copy Code
    fpSpread1.Sheets(0).RemoveColumns(6,2)

    Using Code

    1. Call the RemoveRows or RemoveColumns method for a SheetView object.
    2. Set the row or column parameter to specify the row or column before which to remove the rows or columns.
    3. Set the count parameter to specify the number of rows or columns to remove.

    Example

    This example code removes two columns before column 6.

    C#
    Copy Code
    FarPoint.Win.Spread.SheetView Sheet0;
    Sheet0 = fpSpread1.Sheets[0];
    Sheet0.RemoveColumns(6,2);
    VB
    Copy Code
    Dim Sheet0 As FarPoint.Win.Spread.SheetView
    Sheet0 = fpSpread1.Sheets(0)
    Sheet0.RemoveColumns(6, 2)

    Using the Spread Designer

    1. Select the sheet tab for the sheet for which you want to remove a row or column.
    2. Select the row(s) or column(s) to remove by selecting the header(s).
    3. Right-click on the row or column and choose Delete.
    4. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.