Delete Rows and Columns
This topic demonstrates how to delete rows and columns from a worksheet using the Aspose.Cells.GridWeb API. With the help of this feature, developers can delete rows or columns at runtime.
Deleting Rows
To delete a row from your worksheet:
- Add the Aspose.Cells.GridWeb control to a Web Form.
- Access the worksheet from which you are deleting rows.
- Delete a row from the worksheet by specifying its row index.
Deleting Columns
To delete a column from your worksheet:
- Add the Aspose.Cells.GridWeb control to a Web Form.
- Access the worksheet from which you want to delete columns.
- Delete a column from the worksheet by specifying its column index.
You can also use the DeleteRows/DeleteColumns methods to delete multiple rows or columns in the worksheets.