Visual Studio Tools for Office

出版者:Addison-Wesley Professional

作者:Eric Carter

页数:1120

出版时间:2006-04-26

价格:USD 49.99

装帧:Paperback

isbn号码:9780321411754

具体描述

"With the application development community so focused on the Smart Client revolution, a book that covers VSTO from A to Z is both important and necessary. This book lives up to big expectations. It is thorough, has tons of example code, and covers Office programming in general terms-topics that can be foreign to the seasoned .NET developer who has focused on ASP.NET applications for years. Congratulations to Eric Lippert and Eric Carter for such a valuable work!" -Tim Huckaby, CEO, InterKnowlogy, Microsoft regional director "This book covers in a clear and concise way all of the ins and outs of programming with Visual Studio Tools for Office. Given the authors' exhaustive experiences with this subject, you can't get a more authoritative description of VSTO than this book!" -Paul Vick, technical lead, Visual Basic .NET, Microsoft Corporation"Eric and Eric really get it. Professional programmers will love the rich power of Visual Studio and .NET, along with the ability to tap into Office programmability. This book walks you through programming Excel, Word, InfoPath, and Outlook solutions." -Vernon W. Hui, test lead, Microsoft Corporation "This book is an in-depth, expert, and definitive guide to programming using Visual Studio Tools for Office 2005. It is a must-have book for anyone doing Office development." -Siew Moi Khor, programmer/writer, Microsoft Corporation "We don't buy technical books for light reading. We buy them as a resource for developing a solution. This book is an excellent resource for someone getting started with Smart Client development. For example, it is common to hear a comment along the lines of, 'It is easy to manipulate the Task Pane in Office 2003 using VSTO 2005,' but until you see something like the example at the start of Chapter 15, it is hard to put 'easy' into perspective. This is a thorough book that covers everything from calling Office applications from your application, to building applications that are Smart Documents. It allows the traditional Windows developer to really leverage the power of Office 2003." -Bill Sheldon, principal engineer, InterKnowlogy, MVP "Eric Carter and Eric Lippert have been the driving force behind Office development and Visual Studio Tools for Office 2005. The depth of their knowledge and understanding of VSTO and Office is evident in this book. Professional developers architecting enterprise solutions using VSTO 2005 and Office System 2003 now have a new weapon in their technical arsenal." -Paul Stubbs, program manager, Microsoft Corporation "This book is both a learning tool and a reference book, with a richness of tables containing object model objects and their properties, methods, and events. I would recommend it to anyone considering doing Office development using the .NET framework, especially people interested in VSTO programming." -Rufus Littlefield, software design engineer/tester, Microsoft Corporation Visual Studio Tools for Office is both the first and the definitive book on VSTO 2005 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Visual Studio .NET and the .NET Framework to put code behind Excel 2003, Word 2003, Outlook 2003, and InfoPath 2003. VSTO provides functionality never before available to the Office developer: data binding and data/view separation, design-time views of Excel and Word documents inside Visual Studio, rich support for Windows Forms controls in a document, the ability to create custom Office task panes, server-side programming support against Office, and much more. Carter and Lippert cover their subject matter with deft insight into the needs of .NET developers learning VSTO. This book * Explains the architecture of Microsoft Office programming and introduces the object models * Teaches the three basic patterns of Office solutions: Office automation executables, Office add-ins, and code behind a document * Explores the ways of customizing Excel, Word, Outlook, and InfoPath, and plumbs the depths of programming with their events and object models * Introduces the VSTO programming model * Teaches how to use Windows Forms in VSTO and how to work with the Actions Pane * Delves into VSTO data programming and server data scenarios * Explores .N ET code security and VSTO deployment Advanced material covers working with XML in Word and Excel, developing COM add-ins for Word and Excel, and creating Outlook add-ins with VSTO. The complete code samples are available on the book's Web page.

用户评价

阅读这本书的过程，与其说是学习编程，不如说是一种“思维模式的重塑”。以前写VBA，总觉得代码和Office应用之间是紧密耦合、难以分离的。但这本书系统地阐述了如何通过强类型语言（C#或VB.NET）来构建与Office主机环境相隔离的业务逻辑层。最让我眼前一亮的是它关于“缓存策略”的讨论。在处理大型数据集的Excel集成时，如果直接操作工作表，性能的下降是灾难性的。作者提供了一套基于内存数据结构预处理后，再批量写入/读取的方案，并给出了详尽的代码示例，这个示例复杂到足以应对一个中等规模的财务报表自动化需求。更重要的是，它不仅仅展示了如何“做”，还探讨了在不同版本的Office环境下，哪些优化技巧可能会失效，这体现了作者对技术栈历史演变的深刻理解。这种前瞻性和对潜在“坑点”的预警，让读者在编码时就自带了一层“防御性编程”的盔甲。对于那些希望将自己的Office解决方案商业化或企业内部标准化的技术人员来说，这些章节是无价之宝。

总的来说，这本《Visual Studio Tools for Office》与其说是一本技术指南，不如说是一份沉甸甸的“实践宣言”。它并没有承诺任何魔术般的解决方案，而是坦诚地展示了在微软生态系统中，如何用现代.NET框架的能力去驯服和扩展Office软件的潜力。我从中学到的，不仅仅是特定的类库调用，更重要的是如何在高安全、高并发、多版本的复杂环境中，构建一个稳定、可维护的Office解决方案。书中对COM模型和托管代码之间交互的解释，第一次让我真正理解了为什么有些操作在特定环境下会慢如蜗牛，而通过调整结构后又能瞬间提速。如果你指望它能教你如何写出炫酷的动画效果，那可能会让你失望；但如果你渴望构建能真正解决实际业务痛点、能长期稳定运行的自动化工具，那么这本书的深度和广度，绝对是市场上少有的标杆之作。它需要耐心和时间去啃食，但每一次深入，都会带来知识结构上的质变。

说实话，我最初对这本书的期望值是“能让我快速上手做点小工具”，但深入阅读后，我意识到这套书的格局远不止于此。它更像是一份“Office平台架构师的指南”。尤其是在讨论文档级项目（Document-Level Projects）和应用程序级项目（Application-Level Projects）的切换与数据持久化策略时，作者展现出了惊人的洞察力。我特别留意了书中关于“部署策略”的那几个章节，那简直就是实战的血泪史总结。很多开发者往往只关注代码实现，却在部署和签名证书这一关栽了跟头，导致辛苦开发的解决方案无法在用户的机器上安全运行。这本书没有敷衍了事地提一句“请注意安全证书”，而是详细拆解了ClickOnce部署的陷阱，以及如何利用WPF或Windows Forms控件来构建更复杂的Ribbon界面和自定义任务窗格，让Office不再只是一个简单的文档编辑器，而变成了一个功能强大的业务前端。我个人非常赞同作者关于“最小化COM引用”的建议，那种对底层性能的极致追求，让这本书的价值超越了普通的应用开发指南，直逼底层原理的剖析。

这本传说中的“Visual Studio Tools for Office”巨著，拿到手的时候，我的心情是无比复杂的。首先，它的装帧设计很有工业感，厚实且带着一种技术手册特有的严肃性，封面上的字体选择也透露出一种不容置疑的专业姿态。我原以为它会是一本枯燥的API参考大全，毕竟涉及到Office的自动化和深度集成，那水可深了去了。翻开第一章，却意外地发现作者采用了非常“脚踏实地”的叙事方式，没有上来就抛出那些令人头晕的COM互操作性细节。相反，它似乎更关注“为什么”我们要用VSTO来做这些事，而不是急着告诉你“怎么做”。这让一个刚从VBA的泥潭里爬出来的新手，感到了一丝希望，仿佛找到了一个更现代、更有前途的开发方向。书中对不同Office应用（Word、Excel、Outlook）的宿主项（Host Items）和宿主控件（Host Controls）的介绍，详略得当，特别是对于如何处理事件模型和数据绑定，讲解得比我之前看过的任何在线教程都要清晰透彻。它没有回避那些老生常谈的兼容性问题，反而将其视为一种需要优雅处理的“技术挑战”，这种态度让我非常欣赏。光是第一部分的绪论，我就花了整整一个下午来消化，因为它不仅仅是在介绍工具，更是在铺设一个面向企业级解决方案的开发蓝图。

这本书的另一大亮点，在于它对“用户体验”的重视程度，这在技术手册中是相对罕见的品质。许多技术书籍只关注“能跑起来”，而忽略了“用起来顺不顺手”。作者在讲解如何定制Ribbon界面时，非常细致地讨论了图标设计规范、上下文敏感的菜单设计，甚至提到了如何利用`OnAction`属性来确保回调函数的健壮性，避免因用户误操作导致程序崩溃。在处理Outlook的邮件流程自动化时，它甚至深入到了MAPI子系统的一些概念，这对于构建复杂的邮件分发和分析工具至关重要。我尤其欣赏书中关于“错误处理与日志记录”的章节，作者强调，Office插件的错误不应该简单地弹出一个“运行时错误”，而是应该被优雅地捕获，并记录到本地文件或中央服务器，这对于企业级支持团队来说是决定性的功能。这种对端到端流程的关注，让这本书的使用价值从“开发工具箱”提升到了“项目交付标准”。