Partilhar via


ControlCollection Interface

Represents a collection of managed controls on an Excel worksheet in an Office solution.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
<GuidAttribute("0B027FC3-018C-4917-AE33-A09E0A30A661")> _
Public Interface ControlCollection _
    Inherits IEnumerable
[GuidAttribute("0B027FC3-018C-4917-AE33-A09E0A30A661")]
public interface ControlCollection : IEnumerable

The ControlCollection type exposes the following members.

Properties

  Name Description
Public property Count Gets the number of controls in the ControlCollection.
Public property Item[Int32] Gets the control at the specified index.
Public property Item[String] Gets the control with the specified name.

Top

Methods

  Name Description
Public method _VtblGap1_5 Infrastructure.
Public method AddChart(Range, String) Adds a new Chart control to the worksheet at the range specified.
Public method AddChart(Double, Double, Double, Double, String) Adds a new Chart control to the worksheet in the specified size and location.
Public method AddControl(Control, Range, String) Adds the specified Control to the ControlCollection at the specified range.
Public method AddControl(Control, Double, Double, Double, Double, String) Adds the specified Control to the ControlCollection at the location and size specified.
Public method AddListObject(ListObject) Adds a Visual Studio Microsoft.Office.Tools.Excel.ListObject to the control collection based on the specified native Microsoft.Office.Interop.Excel.ListObject.
Public method AddListObject(Range, String) Adds a new ListObject control to the worksheet at the range specified.
Public method AddNamedRange Adds a new NamedRange control to the worksheet at the range specified.
Public method Contains(Object) Determines whether the specified control is a member of the ControlCollection instance.
Public method Contains(String) Determines whether a control with the specified name is a member of the ControlCollection instance.
Public method GetEnumerator Returns an enumerator that iterates through a collection. (Inherited from IEnumerable.)
Public method IndexOf(Object) Searches for the specified control and returns the zero-based index of the first occurrence in the ControlCollection instance.
Public method IndexOf(String) Searches for the first occurrence of a control with the specified name in the ControlCollection instance.
Public method Remove(Object) Removes the specified control from the ControlCollection instance.
Public method Remove(String) Removes the control with the specified name from the ControlCollection instance.
Public method RemoveAt Removes the control at the specified index in the ControlCollection instance.

Top

Extension Methods

  Name Description
Public Extension Method AddButton(Range, String) Overloaded. Adds a new Button control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddButton(Double, Double, Double, Double, String) Overloaded. Adds a new Button control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddCheckBox(Range, String) Overloaded. Adds a new CheckBox control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddCheckBox(Double, Double, Double, Double, String) Overloaded. Adds a new CheckBox control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddCheckedListBox(Range, String) Overloaded. Adds a new CheckedListBox control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddCheckedListBox(Double, Double, Double, Double, String) Overloaded. Adds a new CheckedListBox control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddComboBox(Range, String) Overloaded. Adds a new ComboBox control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddComboBox(Double, Double, Double, Double, String) Overloaded. Adds a new ComboBox control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddDataGridView(Range, String) Overloaded. Adds a new DataGridView control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddDataGridView(Double, Double, Double, Double, String) Overloaded. Adds a new DataGridView control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddDateTimePicker(Range, String) Overloaded. Adds a new DateTimePicker control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddDateTimePicker(Double, Double, Double, Double, String) Overloaded. Adds a new DateTimePicker control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddDomainUpDown(Range, String) Overloaded. Adds a new DomainUpDown control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddDomainUpDown(Double, Double, Double, Double, String) Overloaded. Adds a new DomainUpDown control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddHScrollBar(Range, String) Overloaded. Adds a new HScrollBar control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddHScrollBar(Double, Double, Double, Double, String) Overloaded. Adds a new HScrollBar control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddLabel(Range, String) Overloaded. Adds a new Label control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddLabel(Double, Double, Double, Double, String) Overloaded. Adds a new Label control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddLinkLabel(Range, String) Overloaded. Adds a new LinkLabel control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddLinkLabel(Double, Double, Double, Double, String) Overloaded. Adds a new LinkLabel control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddListBox(Range, String) Overloaded. Adds a new ListBox control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddListBox(Double, Double, Double, Double, String) Overloaded. Adds a new ListBox control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddListView(Range, String) Overloaded. Adds a new ListView control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddListView(Double, Double, Double, Double, String) Overloaded. Adds a new ListView control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddMaskedTextBox(Range, String) Overloaded. Adds a new MaskedTextBox control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddMaskedTextBox(Double, Double, Double, Double, String) Overloaded. Adds a new MaskedTextBox control to the document in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddMonthCalendar(Range, String) Overloaded. Adds a new MonthCalendar control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddMonthCalendar(Double, Double, Double, Double, String) Overloaded. Adds a new MonthCalendar control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddNumericUpDown(Range, String) Overloaded. Adds a new NumericUpDown control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddNumericUpDown(Double, Double, Double, Double, String) Overloaded. Adds a new NumericUpDown control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddPictureBox(Range, String) Overloaded. Adds a new PictureBox control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddPictureBox(Double, Double, Double, Double, String) Overloaded. Adds a new PictureBox control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddProgressBar(Range, String) Overloaded. Adds a new ProgressBar control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddProgressBar(Double, Double, Double, Double, String) Overloaded. Adds a new ProgressBar control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddPropertyGrid(Range, String) Overloaded. Adds a new PropertyGrid control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddPropertyGrid(Double, Double, Double, Double, String) Overloaded. Adds a new PropertyGrid control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddRadioButton(Range, String) Overloaded. Adds a new RadioButton control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddRadioButton(Double, Double, Double, Double, String) Overloaded. Adds a new RadioButton control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddRichTextBox(Range, String) Overloaded. Adds a new RichTextBox control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddRichTextBox(Double, Double, Double, Double, String) Overloaded. Adds a new RichTextBox control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddTextBox(Range, String) Overloaded. Adds a new TextBox control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddTextBox(Double, Double, Double, Double, String) Overloaded. Adds a new TextBox control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddTrackBar(Range, String) Overloaded. Adds a new TrackBar control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddTrackBar(Double, Double, Double, Double, String) Overloaded. Adds a new TrackBar control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddTreeView(Range, String) Overloaded. Adds a new TreeView control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddTreeView(Double, Double, Double, Double, String) Overloaded. Adds a new TreeView control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddVScrollBar(Range, String) Overloaded. Adds a new VScrollBar control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddVScrollBar(Double, Double, Double, Double, String) Overloaded. Adds a new VScrollBar control to the worksheet in the specified size and location. (Defined by ControlExtensions.)
Public Extension Method AddWebBrowser(Range, String) Overloaded. Adds a new WebBrowser control to the worksheet at the range specified. (Defined by ControlExtensions.)
Public Extension Method AddWebBrowser(Double, Double, Double, Double, String) Overloaded. Adds a new WebBrowser control to the worksheet in the specified size and location. (Defined by ControlExtensions.)

Top

Remarks

Use the methods and properties of the ControlCollection interface to manage controls on an Excel worksheet. For more information, see Adding Controls to Office Documents at Run Time.

You cannot create an instance of this interface in your code, because it does not have any public constructors. To get an instance of this interface in a document-level project, use the Controls property of one of the Sheetn classes in your project. To get an instance of this interface in a document-level project, use the Controls property of a Worksheet host item that you create programmatically at run time. For more information, see Extending Word Documents and Excel Workbooks in Application-Level Add-ins at Run Time.

The following table shows how to use ControlCollection members to perform some common tasks related to controls on documents.

Task

Action

Add a control to the worksheet.

Use one of the Add<control> methods. For example, to add a Microsoft.Office.Tools.Excel.ListObject, use the AddListObject method.

Remove a control from the worksheet.

Use the Remove method.

Determine whether a control is in the collection.

Pass the control or its name to the Contains method.

Get the index of a control in the collection.

Pass the control or its name to the IndexOf method.

Get a control from the collection.

Pass the index or name of the control to the Item property.

Note

This interface is implemented by the Visual Studio Tools for Office runtime. It is not intended to be implemented in your code. For more information, see Visual Studio Tools for Office Runtime Overview.

Usage

This documentation describes the version of this type that is used in Office projects that target the .NET Framework 4 and the .NET Framework 4.5. In projects that target the .NET Framework 3.5, this type might have different members and the code examples provided for this type might not work. For documentation about this type in projects that target the .NET Framework 3.5, see the following reference section in the Visual Studio 2008 documentation: https://go.microsoft.com/fwlink/?LinkId=160658.

See Also

Reference

Microsoft.Office.Tools.Excel Namespace