WorksheetExtensions.GetVstoObject Method (_Worksheet, Factory)
Returns a Microsoft.Office.Tools.Excel.Worksheet host item that extends the functionality of the current Microsoft.Office.Interop.Excel.Worksheet object in a document-level customization. Pass the Globals.Factory object in your project to the factory parameter.
Namespace: Microsoft.Office.Tools.Excel.Extensions
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
<ExtensionAttribute> _
Public Shared Function GetVstoObject ( _
worksheet As _Worksheet, _
factory As Factory _
) As Worksheet
public static Worksheet GetVstoObject(
this _Worksheet worksheet,
Factory factory
)
Parameters
- worksheet
Type: Microsoft.Office.Interop.Excel._Worksheet
The native worksheet object to extend. Do not supply this parameter yourself. When you call this method on an Excel worksheet, the runtime supplies this parameter.
- factory
Type: Microsoft.Office.Tools.Excel.Factory
An object that provides access to certain features in your document-level customization. Pass the Globals.Factory object to this parameter.
Return Value
Type: Microsoft.Office.Tools.Excel.Worksheet
A host item that extends the functionality of the current Microsoft.Office.Interop.Excel.Worksheet object.
Usage Note
In Visual Basic and C#, you can call this method as an instance method on any object of type _Worksheet. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).
Remarks
In a document-level customization, you can call this method to get a Microsoft.Office.Tools.Excel.Worksheet host item that is in the current customization. If the Microsoft.Office.Interop.Excel.Worksheet object on which you call this method is not the underlying object of a Microsoft.Office.Tools.Excel.Worksheet host item in the current customization, this method returns nulla null reference (Nothing in Visual Basic).
This method is provided for backward compatibility with Office projects that you retarget from the .NET Framework 3.5 to the .NET Framework 4. In new projects that target the .NET Framework 4, you should call the GetVstoObject method that is provided by the Globals.Factory object in your project. For more information, see Getting Extended Objects from Native Office Objects in Document-Level Customizations.
Note
The worksheet parameter is of type Microsoft.Office.Interop.Excel._Worksheet, which is the parent interface of Microsoft.Office.Interop.Excel.Worksheet. Therefore, this method extends both types: Microsoft.Office.Interop.Excel._Worksheet and Microsoft.Office.Interop.Excel.Worksheet. Typically, when you reference an Excel worksheet, you use a Microsoft.Office.Interop.Excel.Worksheet.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.
See Also
Reference
Microsoft.Office.Tools.Excel.Extensions Namespace
Other Resources
Getting Extended Objects from Native Office Objects in Document-Level Customizations