WorksheetExtensions Class

Definition

Namespace:

Microsoft.Office.Tools.Excel.Extensions

Assembly:

Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Provides methods you can use to extend Microsoft Office Excel worksheets by generating host items for Worksheet objects and by testing for the existence of the generated host items.

public ref class WorksheetExtensions abstract sealed

public static class WorksheetExtensions

type WorksheetExtensions = class

Public Module WorksheetExtensions

Inheritance

Object

WorksheetExtensions

Remarks

The WorksheetExtensions class contains extension methods that are designed to be accessed on Microsoft.Office.Interop.Excel.Worksheet objects. For more information about extension methods, see Extension Methods and Extension Methods.

The extension methods in the WorksheetExtensions class are provided for backward compatibility with Office projects that you retarget from the .NET Framework 3.5 to the .NET Framework 4 or the .NET Framework 4.5. In new projects that target the .NET Framework 4 or the .NET Framework 4.5, you should call the GetVstoObject and HasVstoObject methods that are provided by the Globals.Factory object in your project. For more information, see Extending Word Documents and Excel Workbooks in VSTO Add-ins at Run Time and Programming Document-Level Customizations.

Methods

GetVstoObject(_Worksheet, ApplicationFactory)	Returns a Worksheet host item that extends the functionality of the current Worksheet object in an application-level add-in. Pass the Globals.Factory object in your project to the factory parameter.
GetVstoObject(_Worksheet, Factory)	Returns a Worksheet host item that extends the functionality of the current Worksheet object in a document-level customization. Pass the Globals.Factory object in your project to the factory parameter.
HasVstoObject(_Worksheet, ApplicationFactory)	Returns a value that indicates whether a Worksheet host item has been created for the current Worksheet object in an application-level add-in. Pass the Globals.Factory object in your project to the factory parameter.
HasVstoObject(_Worksheet, Factory)	Returns a value that indicates whether a Worksheet host item has been created for the current Worksheet object in a document-level customization. Pass the Globals.Factory object in your project to the factory parameter.