ExcelFile.AddComboBox Method
Adds a ComboBox to the active sheet.
Remarks
Excel supports 2 types of comboboxes: ActiveX and internal (In Excel you would add them from the "ActiveX" and "Forms" toolbars respectively) The comboboxes added by this method are of type internal. ActiveX comboboxes are not supported.
Syntax
Namespace: FlexCel.Core
public abstract Int32 AddComboBox(TClientAnchor anchor, String name, TCellAddress linkedCell, TCellAddressRange inputRange, Int32 selectedItem)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
anchor | TClientAnchor | Position for the combobox. | |
name | String | Name of the inserted combobox. | |
linkedCell | TCellAddress | Cell that will be linked to the combobox. Set this to null to not link any cell. | |
inputRange | TCellAddressRange | Range of cells with the values that the combobox will display. | |
selectedItem | Int32 | Item that will be selected, starting at 1. 0 means no selected item. |
Returns
Object Index of the inserted combobox (1 based).