Managing Cell Controls in Columns

This topic discusses some important concepts about managing cell controls in columns using the Aspose.Cells.GridDesktop API. We will explain how developers can access, modify, and remove cell controls from the columns of their worksheets. Let’s have a look.

Accessing Cell Controls

To access and modify an existing cell control in the column, developers can use the CellControl property of an Aspose.Cells.GridDesktop.Data.GridColumn. Once a cell control is accessed, developers can modify its properties at runtime. For instance, in the example given below, we access an existing CheckBox cell control from a specific Aspose.Cells.GridDesktop.Data.GridColumn and modify its Checked property.

IMPORTANT: The CellControl property provides a cell control in the form of a CellControl object. So, if you need to access a specific type of cell control, say CheckBox, then you will have to type‑cast the CellControl object to the CheckBox class.

Removing Cell Controls

To remove an existing cell control, developers can simply access the desired worksheet and then Remove the cell control from the specific column by using the RemoveCellControl method of Aspose.Cells.GridDesktop.Data.GridColumn.

Each column in the Columns collection of the Worksheet is represented by an instance of the Aspose.Cells.GridDesktop.Data.GridColumn class.