Visual Studio Tools for Office (VSTO) 3.0编程指南

需积分: 10 187 浏览量更新于2024-07-22 收藏 5.93MB PDF 举报

"ackt.Publishing.VSTO.3.0.for.Office.2007.Programming." 本书聚焦于“Visual Studio Tools for Office (VSTO) 3.0 for Office 2007 Programming”，作者Vivek Thangaswamy，由Packt Publishing出版。VSTO是微软提供的一套开发工具，它允许开发者利用Visual Studio和.NET Framework来扩展Microsoft Office应用程序，包括Word、Excel、PowerPoint等。 VSTO 3.0是VSTO的一个版本，它主要针对Office 2007系统。在这个版本中，开发者可以利用C#、VB.NET等编程语言，构建出与Office界面深度集成的解决方案，创建自定义功能区、任务窗格、表单区域、宏以及自动化工作流程等。该技术允许开发者通过COM互操作性访问Office对象模型，实现对Office文档的高级定制和自动化。在本书中，读者将学习如何： 1. **环境设置与项目创建**：了解如何配置开发环境，安装必要的软件，如Visual Studio和VSTO 3.0运行时，以及如何创建第一个VSTO项目。 2. **Office对象模型**：探索Office应用程序（如Word或Excel）的对象模型，理解如何使用这些对象来操作文档、工作簿、工作表等元素。 3. **用户界面定制**：学习如何创建自定义功能区，添加自定义按钮、下拉列表和其他控件，以提供用户友好的交互体验。 4. **事件处理和自动化**：掌握如何响应Office应用程序中的事件，编写自动化脚本，自动执行一系列操作，提高办公效率。 5. **表单区域设计**：学习在Outlook中创建和设计自定义表单区域，以满足特定的业务需求。 6. **数据绑定和业务逻辑**：了解如何将VSTO解决方案与数据库或其他数据源绑定，以及如何实现复杂的业务逻辑。 7. **部署与安全**：学习使用ClickOnce或Windows Installer (MSI) 技术部署VSTO解决方案，同时理解安全考虑和权限管理。 8. **错误处理和调试**：掌握在VSTO开发中的错误处理策略，以及如何有效地调试VSTO应用。 9. **最佳实践与案例研究**：书中可能包含了实际项目中的案例研究，帮助读者理解如何将理论知识应用到实际开发场景中，遵循最佳实践。请注意，虽然本书出版于2009年，但VSTO的基本概念和原理至今仍然适用。尽管后来的VSTO版本可能引入了新的特性，但对VSTO 3.0的理解对于初学者和经验丰富的开发者来说都是有价值的。这本书旨在帮助开发者迅速掌握VSTO 3.0编程，通过实例和详细解释，提升他们开发Office应用程序的能力。无论你是希望通过VSTO增强现有Office应用的功能，还是希望创建全新的定制解决方案，本书都是一份宝贵的参考资料。

Chapter No.

[ 3 ]

A block of code will be set as follows:

private void ThisAddIn_Startup(object sender, System.EventArgs e)

{

// Creating PowerPoint presentation with single slide in it

// Using the PowerPoint object instance adding the

// Slide with text title structure to the current Presentation

PowerPoint.Presentation PacktPresentation = this.Application.

Presentations.Add(Microsoft.Office.Core.MsoTriState.

msoTriStateMixed);

}

New terms and important words are introduced in a bold-type font. Words that you

see on the screen, in menus or dialog boxes for example, appear in our text like this:

"As it can be seen in the following screenshot, Say Hello World is displayed in a

message box:".

Warnings or important notes appear in a box like this.

Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about

this book—what you liked or may have disliked. Reader feedback is important for

us to develop titles that you really get the most out of.

To send us general feedback, simply send an email to

feedback@packtpub.com,

making sure that you mention the book title in the subject of your message.

If there is a book that you need and would like to see us publish, please send

us a note via the SUGGEST A TITLE form on

www.packtpub.com, or send an

email to suggest@packtpub.com.

If there is a topic that you have expertise in and you are interested in either writing

or contributing to a book on, see our author guide on

www.packtpub.com/authors.

Chapter 1

[ 7 ]

Using VSTO, Ofce developers can build solutions such as Add-Ins; Add-Ins are

additional program components that can be added to Ofce applications by using

VSTO. For example, Microsoft offers a few free add-ins for Ofce 2007 licensed

users, such as the 2007 Microsoft Ofce add-in Microsoft Save as PDF or XPS—this

add-in facilitates the saving of a document in PDF or XPS format. You can also

customize existing Ofce application features, and you can program against existing

options available in the Ofce application. Let's say you need to save or export all of

the content from Microsoft Ofce Word 2007 to Microsoft Ofce Excel 2007 on the

click event of a button placed on the toolbar, or during some action.You can create an

add-in for this kind of activity using VSTO. This is one scenario where you can use a

VSTO add-in for your Ofce solution development.

Before VSTO, Ofce developers had to use VBA, VB6, or C++ to create so called

shared COM Add-Ins. All Add-Ins share the same address space, and if one fails,

the host application or all other Add-Ins crash. Unlike VSTO, VBA code is written

directly in the Ofce application's IDE and is compiled at run-time. All VBA scripts

are stored inside the document for which you were programming. In VSTO, this is

termed a document-level solution, where the solution is specic to the document

for which it is deployed. Similarly, in VSTO, document level add-ins are delivered

within a specic document. For example, let's say that you include functions in a

specic Microsoft Ofce Word document—the functions are available only when

you open that particular Word document. Document level add-ins are relevant only

to Word and Excel. Document-level customizations are the VSTO version of VBA

macros in Word or Excel.

VSTO introduces a new concept called application-level solutions. With an

application-level solution, the solution is accessible for all documents processed

through that particular application. You can build application-level solutions by

using the application-level add-in for your solution development.

VSTO gives you two fully-supported programming languages in which to build

Microsoft Ofce solutions that will run in all Microsoft Ofce applications—C#,

VB.NET, or XML. As a VSTO programmer, you will need to have a basic knowledge

of C# to program Ofce applications using C#. In this book, we will assume that you

have a basic knowledge of C# concepts such as classes, namespaces, and methods. In

addition, you should know the basics of XML.

The following MSDN reference link will help you learn about .NET

and C#: http://msdn.microsoft.com/en-us/vcsharp/

aa336804.aspx

剩余259页未读，继续阅读

dreamwander

粉丝: 1
资源: 3

Visual Studio Tools for Office (VSTO) 3.0编程指南

VSTO_3.0_for_Office_2007_Progr.pdf_pdf_VSTO_ridehmf_源码

VSTO 3.0 for Office 2007 Programming

Holy.Macro.Books.From.VBA.to.VSTO.Is.Excels.New.Engine.Right.for.You

VSTO4_10_Office2010RibbonDemo.rar_DEMO_VSTO_c# vsto_vsto word

VSTO 3.0 office2007程序设计

Wrox.Professional.VSTO.2005.Visual.Studio.2005.Tools.for.Office.May.2006

Deploying a VSTO 3.0 solution for the Office 2007 using Windows Installers

addison.wesley.visual.studio.tools.for.office.using.c.sharp.with.excel.word.outlook.and.infopath

Visual.Studio.Tools.for.Office.Using.C.Sharp.with.Excel.Word.Outlook.and.InfoPath.Sep.2005

vsto programming

最新资源