This topic explains how to manage worksheet’s cells, columns and rows.
The following topics are prerequisites to understanding this topic:
This topic contains the following sections:
The Infragistics Excel Engine supports inserting of new cell(s) and removing of existing cell(s) using methods located in the Worksheet class.
The following table explains briefly the available functionality for inserting and deleting worksheet cell(s). Further details are available after the table.
The Infragistics Excel Engine supports inserting of one or more new cell(s) by specifying the location at which the insert process should occur. The cell(s) already located at the specified address(es) will be shifted to the right or below. You can specify the address(es) for the new cell(s) using a string
or a WorksheetRegion.
Here are some examples of specifying addresses using a string
:
“C5” - this will insert one single cell at column C, row 5
“D8:D10” – this will insert 3 cells in column D, rows 8, 9 and 10
“E11:G15” – this will insert a block of cells which stretch from column E to column G and from row 11 to row 15
The following table maps the desired functionality to the method that invokes it.
The Infragistics Excel Engine supports deleting of one or more existing cell(s) by specifying the location at which the deletion process should occur. The “empty” location will be filled with cells from either right or below the deleted cell(s). You can specify the address(es) for the cell(s) to be deleted using string
or WorksheetRegion
.
The following table maps the desired functionality to the method that invokes it.
The Infragistics Excel Engine supports inserting and deleting column(s) using the Insert
and Remove
methods of the worksheet’s Columns collection.
The following table maps the desired functionality to the method that invokes it.
The Infragistics Excel Engine supports inserting and deleting row(s) using the Insert
and Remove
methods of the worksheet’s Rows collection.
The following table maps the desired functionality to the method that invokes it.
The following topics provide additional information related to this topic.