Inserting and Deleting Rows and Columns of Excel file
Whether creating a new worksheet from scratch or working on an existing worksheet, we may need to add extra rows or columns to accommodate more data. Inversely, we may also need to delete rows or columns from specified positions in the worksheet. To fulfill these requirements, Aspose.Cells provides a very simplest set of classes and methods, discussed below.
Manage Rows and Columns
Aspose.Cells provides a class Workbook, that represents a Microsoft Excel file. The Workbook class contains a Worksheets collection that allows access to each worksheet in an Excel file. A worksheet is represented by the Worksheet class. The Worksheet class provides a Cells collection that represents all cells in the worksheet.
The Cells collection provides several methods managing rows and columns in a worksheet. Some of these are discussed below.
Insert Rows and Columns
Insert a Row
Insert Multiple Rows
- Row index, the index of the row from where the new rows will be inserted.
- Number of rows, the total number of rows that need to be inserted.
Insert a Row with Formatting
To insert a row with formatting options, use the InsertRows overload that takes InsertOptions as a parameter. Set the CopyFormatType property of InsertOptions class with CopyFormatType Enumeration. The CopyFormatType Enumeration has three members as listed below.
- SameAsAbove: Formats the row same as the above row.
- SameAsBelow: Formats the row same as below row.
- Clear: Clears the formatting.
Insert a Column
Developers can also insert a column into the worksheet at any location by calling the InsertColumn method of the Cells collection. The InsertColumn method takes the index of the column where the new column will be inserted.
Delete Rows and Columns
Delete Multiple Rows
- Row index, the index of the row from where the rows will be deleted.
- Number of rows, the total number of rows that need to be deleted.