Unlike a document-level customization, which is associated with a specific workbook, functionality that you implement in a VSTO Add-in is not restricted to any single workbook. The assembly typically extends Excel by customizing the UI and by automating Excel. Develop VSTO Add-ins for ExcelĪ VSTO Add-in for Microsoft Office Excel consists of an assembly that is loaded by Excel. These classes represent the workbook and worksheets that are associated with your solution, and they provide a starting point for writing your code.įor more information about these generated classes and other features you can use in a document-level project, see Program document-level customizations. When you create a document-level project for Excel, Visual Studio generates several classes that are the foundation of your solution: ThisWorkbook, Sheet1, Sheet2, and Sheet3. For more information, see How to: Create Office projects in Visual Studio.įor more information about how document-level customizations work, see Architecture of document-level customizations. To create a document-level customization project for Excel, use the Excel workbook or Excel template project templates in the New Project dialog box of Visual Studio. Unlike a VSTO Add-in, which is associated with Excel itself, functionality that you implement in a customization is available only when the associated workbook is open in Excel. The assembly typically extends the workbook by customizing the UI and by automating Excel. Develop document-level customizations for ExcelĪ document-level customization for Microsoft Office Excel consists of an assembly that is associated with a specific workbook. For more information, see Automate Excel by using extended objects. The extended objects behave like the Excel objects they are based on, but they add additional events and data binding capabilities to the objects. These are objects that extend certain commonly used objects in the Excel object model, such as the Worksheet and Range objects. When developing Excel solutions in Visual Studio, you can also use host items and host controls in your solutions. For more information, see Excel object model overview. For example, you can programmatically create charts, format worksheets, and set the values of ranges and cells. The Excel object model exposes many types that you can use to automate Excel. This topic provides the following information:ĭevelop document-level customizations for Excel. Office Add-ins have a small footprint compared to VSTO Add-ins and solutions, and you can build them by using almost any web programming technology, such as HTML5, JavaScript, CSS3, and XML. Interested in developing solutions that extend the Office experience across multiple platforms? Check out the new Office Add-ins model.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |