Gets a Range object that represents one or more columns on the worksheet. ![]() Gets a Range object that represents the range containing the first circular reference on the sheet, or gets null if there is no circular reference on the sheet. Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use). Gets or sets a value that indicates whether filtering is currently enabled on the worksheet (that is, whether the filter drop-down arrows are currently displayed). Gets a AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled. This property gets a Application that represents the Microsoft Office Excel application. NET Framework 3.5, see the following reference section in the Visual Studio 2008 documentation. For documentation about this type 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. This documentation describes the version of this type that is used in Office projects that target the. For more information, see Visual Studio Tools for Office Runtime Overview. It is not intended to be implemented in your code. This interface is implemented by the Visual Studio Tools for Office runtime. For more information, see Programming Document-Level Customizations. This class redirects all calls to its members to an internal implementation of the .Worksheet interface in the Visual Studio Tools for Office runtime. Each Sheet n class derives most of its members from the .WorksheetBase class. Instead, use the Sheet n classes to programmatically access the worksheets in your project. In document-level projects, you typically do not use .Worksheet object directly. For more information, see Extending Word Documents and Excel Workbooks in VSTO Add-ins at Run Time. In application-level projects, you can create .Worksheet objects programmatically by using the GetVstoObject method. That is, in the Excel object model, these events are defined in the .Application class rather than the .Worksheet interface. Worksheet-level events, such as ActivateEvent and Change, that are provided only at the application level in the Excel object model. Use this property to get the underlying .Worksheet object for a .Worksheet host item. Use this property to add managed controls to an Excel worksheet, or to remove controls, at run time. ![]() IComponent ISupportInitialize IDisposable IBindableComponent RemarksĪ .Worksheet object provides the same members as a .Worksheet object from the Excel primary interop assembly, but it adds the following features:Ĭontrols property.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |