You can remove one or more rows or columns from a sheet and you can allow the end user to remove rows or prohibit them from removing rows.
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 Rows or Columns.
Return to the row and column appearance overview at Customizing the Appearance of Rows and Columns.
Using a Shortcut
- Use the RemoveRows or RemoveColumns method for the Sheets shortcut.
- Set the row or column parameter to specify the first row or column to remove.
- Set the count parameter to specify the number of rows or columns to remove.
Example
This example code removes two rows.
| C# |  Copy Code |
|---|---|
FpSpread1.Sheets[0].RemoveRows(6,2); |
|
| VB | Copy Code |
|---|---|
FpSpread1.Sheets(0).RemoveRows(6,2) |
|
Using Code
- Use the RemoveRows or RemoveColumns method for a SheetView object.
- Set the row or column parameter to specify the first row or column to remove.
- Set the count parameter to specify the number of rows or columns to remove.
Example
This example code removes two rows.
| C# | Copy Code |
|---|---|
FarPoint.Web.Spread.SheetView Sheet0; Sheet0 = FpSpread1.Sheets[0]; Sheet0.RemoveRows(6,2); |
|
| VB | Copy Code |
|---|---|
Dim Sheet0 As FarPoint.Web.Spread.SheetView Sheet0 = FpSpread1.Sheets(0) Sheet0.RemoveRows(6, 2) |
|
Using the Spread Designer
- Select the Data menu.
- At the bottom, select the sheet for which you want to remove rows or columns.
- In the Rows or Columns area, select an existing row or column in the list.
- Click the Delete icon. Select Delete Row or Delete Column to remove a row or column.
- Click OK.
- Click Apply and Exit to close the Spread Designer.