Visual Studio 2005 for Office 开发工具 Professional VSTO 2005: Visual Studio 2005 Tools for Office
点此进入淘宝搜索页搜索分類: 图书,计算机/网络,家庭与办公室用书,微软Office ,
作者： Alvin Bruney 著
出 版 社： 吉林长白山
出版时间： 2007-7-1字数：版次： 1页数： 313印刷时间： 2006/05/01开本：印次：纸张： 胶版纸I S B N ： 9780471788133包装： 平装内容简介
Professional Visual Studio 2005 Tools for Office satisfies the need to write enterprise software based on Office by delivering practical solutions for those seeking to port existing functionality to VSTO. The book focuses on code and implementation, not theory, with code examples presented in both VB and C#.
The book is especially written for enterprise developers - VBA or COM Interop savvy - who need to leverage the power and productivity of VSTO today. .NET developers seeking to explore VSTO as a potential solution will also find ample material that suits their needs.
This book covers VSTO 2005 in detail. The approach focuses on the major components that form the suite with the exception that InfoPath is not covered. All other components benefit from an exploration of the key objects that are most likely to be used in common programming scenarios. This book is organized into chapters that present the building blocks of VSTO first. Microsoft Excel and its Range objects form the cornerstone of range manipulation across the VSTO suite. For that reason, the first few chapters explain these basic concepts. Subsequent chapters use these building blocks as a starting point so it is important to be familiar with these concepts before skipping to the back of the book.
Once you gain a complete understanding of the Excel Range object in Chapters 2 and 3, you can apply that knowledge to the remaining chapters. In fact, Microsoft Word, Charts and Pivot Table manipulation are all based on the Excel Range object. (VSTO contains a potent charting engine second to none. And this book explores every facet of charting.) The obvious benefit of this clever architecture is that it significantly reduces the learning curve for those who wish to adopt this relatively new technology. And this book is designed to show you how to exploit this architecture.
作者简介
Alvin Bruney is a senior software engineer for Indigo Books and Music. His previous development jobs included spearheading the .NET architecture for NetworkIP, a telecommunications provider, and as a programmer with Intuit. He self-published a book on Office Web Components, and frequently writes articles for ASP.NET Professional magazine, MSDN, and other online venues. He is also a Microsoft .NET MVP and is well known in the 10 newsgroups he monitors.
目录
Acknowledgments
Introduction
Chapter 1: Visual Studio Tools for Office
What's New in VSTO?
VSTO Architecture
The VSTO Package
About Microsoft Office PIAs
System Requirements
Alternatives to the VSTO Office Systems
Disadvantages of VSTO
VSTO Automation
Office XML Schemas
Installation and deployment
VSTO Installation Issues
Summary
Chapter 2: Excel Automation
Excel Data Manipulation
Application Object Manipulation
Workbook Manipulation
Worksheet Manipulation
Excel Range Manipulation
Data Formatting and Presentation
Considerations for Excel Automation
Excel Case Study-time Sheet Software
Summary
Chapter 3: Advanced Excel Automation
VSTO Security
Working with Excel Formulas
Excel Spreadsheet Error Values
Responding to Events
Working with Workbook Controls
Printing Workbook Data
Excel Toolbar Customization
Excel Menu Customization
VSTO and Web Services
Excel Sever Automation
Excel Com Add-Ins
Summary
Chapter 4: Word Automation
Key Application Objects in Word
……
Chapter 5: Outlook Automation
Chapter 6: The Charting Tool
Chapter 7: Pivot Table Automation
Index
