none
Microsoft.Office.Tools.Excel and Microsoft.office.Interop.Excel RRS feed

  • Question

  • Can someone tell the difference between Microsoft.Office.Tools.Excel and Microsoft.office.Interop.Excel as these looks quite similar in usage but they have been explicitly defined everywhere.

    Monday, July 3, 2017 6:50 AM

All replies

  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Regards,
    Emi Zhang
    TechNet Community Support

    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, July 4, 2017 6:03 AM
  • Hi Aditya90u,

    The Microsoft.Office.Tools.Excel namespace contains a set of types that extend and support the Microsoft Office Excel object model in projects created by using the Office development tools in Visual Studio.

    You could get more information from:

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/86a62151-fbf0-4584-a68c-83060fb95c3d/officeinteropexcel?forum=vsto

    https://msdn.microsoft.com/en-us/library/wss56bz7.aspx

    https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.aspx

    Best Regards,

    Terry


    Friday, July 7, 2017 2:09 AM
  • Microsoft.Office.Interop.Excel is a Primary Interop Assembly (PIA) for the Excel COM object model. So it is the .NET wrapper around the Excel COM object model which is used by managed languages to access the Excel COM object model, but doesn't add anything extra to the COM object model. It allows you to reference Worksheet or Range objects from .NET, and you have access to the same object model as you would use from VBA.

    Microsoft.Office.Tools.Excel is a part of the Visual Studio Tools for Office (VSTO) library that was developed by the Microsoft developer division. VSTO is an extension to Office that offers extra high-level classes that are built on top of the COM object model. These extra classes implement binding to ranges and tables, wrappers around names ranges etc. Since VSTO offers extensions to the Excel COM object model, there are similar types and names, and in many cases you can get access to the underlying COM object from the VSTO types, which is why you see similar concepts in both.

    The Excel COM object model (and hence Microsoft.Office.Interop.Excel) is part of the desktop version of Excel and is updated with every Excel version.

    VSTO is a part of the Visual Studio product range, and there were different versions of VSTO which don't overlap exactly with the Excel versions. Although VSTO is available with Visual Studio 2017 and supports Excel 2016, there does not seem to have been any further development on it in recent years.

    -Govert

    Excel-DNA - Free and easy .NET for Excel

    Monday, July 10, 2017 10:19 AM
  • Hi Aditya90u,

    Has your original issue been resolved? If it has, I would suggest you mark the helpful reply as answer.
    If not, please feel free to let us know your current issue.

    Best Regards,

    Terry

    Wednesday, August 2, 2017 7:26 AM