Microsoft.Office.Tools.Excel.Extensions Namespace

  • Article

The Microsoft.Office.Tools.Excel.Extensions namespace provides extension methods that you can access on Microsoft.Office.Interop.Excel.Workbook, Microsoft.Office.Interop.Excel.Worksheet and Microsoft.Office.Interop.Excel.ListObject objects to extend Microsoft Office Excel workbooks, worksheets, and list objects.

The extension methods in this namespace are 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 access these methods by using the Globals.Factory object in your project. For more information, see Extending Word Documents and Excel Workbooks in Application-Level Add-ins at Run Time and Getting Extended Objects from Native Office Objects in Document-Level Customizations.

Classes

  Class Description
Public class ListObjectExtensions Provides methods you can use to extend Microsoft Office Excel list objects by generating host controls for Microsoft.Office.Interop.Excel.ListObject objects and by testing for the existence of the generated host controls.
Public class WorkbookExtensions Provides methods you can use to extend Microsoft Office Excel workbooks by generating host items for Microsoft.Office.Interop.Excel.Workbook objects and by testing for the existence of the generated host items.
Public class WorksheetExtensions Provides methods you can use to extend Microsoft Office Excel worksheets by generating host items for Microsoft.Office.Interop.Excel.Worksheet objects and by testing for the existence of the generated host items.