Insert Rows and Columns

This topic explains how to insert new rows and columns into a worksheet using the Aspose.Cells.GridWeb API. Rows or columns can be inserted at any position in the worksheet.

Inserting Rows

To insert a row at any position in a worksheet:

1. Add the Aspose.Cells.GridWeb control to a Web Form.
2. Access the worksheet you’re adding rows to.
3. Insert a row by specifying the row index at which the row will be inserted.

Inserting Columns

To insert a column at any position in a worksheet:

1. Add the Aspose.Cells.GridWeb control to a Web Form.
2. Access the worksheet you’re adding columns to.
3. Insert a column by specifying the column index at which the column will be inserted.

You can also use the InsertRows/InsertColumns methods to insert multiple rows or columns into the worksheets accordingly.