Overview

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 .NET code security and VSTO deployment

Full Product Details

Author:   Eric Carter ,  Eric Lippert
Publisher:   Pearson Education (US)
Imprint:   Addison Wesley
ISBN:  

9780132701754

ISBN 10:   0132701758
Pages:   1056
Publication Date:   06 May 2006
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Undefined
Publisher's Status:   Active
Availability:   Available To Order  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

Figures xxxi Tables xlv Foreword xlix Preface liii Acknowledgments lvii About the Authors lix Part I: An Introduction to VSTO 1 Chapter 1: An Introduction to Office Programming 3 Why Office Programming? 3 Office Object Models 6 Properties, Methods, and Events 12 The Office Primary Interop Assemblies (PIAs) 34 Conclusion 43 Chapter 2: Introduction to Office Solutions 45 The Three Basic Patterns of Office Solutions 45 Office Automation Executables 49 Office Add-Ins 60 Code Behind a Document 65 Conclusion 72 Part II: Office Programming in .NET 73 Chapter 3: Programming Excel 75 Ways to Customize Excel 75 Programming User-Defined Functions 83 Introduction to the Excel Object Model 92 Conclusion 98 Chapter 4: Working with Excel Events 99 Events in the Excel Object Model 99 Events in Visual Studio 2005 Tools for Office 138 Conclusion 142 Chapter 5: Working with Excel Objects 143 Working with the Application Object 143 Working with the Workbooks Collection 157 Working with the Workbook Object 161 Working with the Worksheets, Charts, and Sheets Collections 169 Working with Document Properties 172 Working with the Windows Collections 175 Working with the Window Object 179 Working with the Names Collection and Name Object 181 Working with the Worksheet Object 183 Working with the Range Object 197 Special Excel Issues 213 Conclusion 220 Chapter 6: Programming Word 223 Ways to Customize Word 223 Programming Research Services 229 Introduction to the Word Object Model 237 Conclusion 238 Chapter 7: Working with Word Events 243 Events in the Word Object Model 243 Why Are There Multiple Application and Document Event Interfaces? 244 Events in Visual Studio Tools for Office 273 Conclusion 275 Chapter 8: Working with Word Objects 277 Working with the Application Object 277 Working with the Dialog Object 299 Working with Windows 304 Working with Templates 307 Working with Documents 310 Working with a Document 315 Working with the Range Object 335 Working with Bookmarks 358 Working with Tables 360 Conclusion 362 Chapter 9: Programming Outlook 363 Ways to Customize Outlook 363 Custom Property Pages 370 Introduction to the Outlook Object Model 378 Introduction to the Collaboration Data Objects 382 Conclusion 386 Chapter 10: Working with Outlook Events 387 Events in the Outlook Object Model 387 Application-Level Events 392 Outlook Item Events 405 Other Events 419 Conclusion 422 Chapter 11: Working with Outlook Objects 423 Working with the Application Object 423 Working with the Explorers and Inspectors Collections 431 Working with the Explorer Object 433 Working with the Inspector Object 440 Working with the NameSpace Object 443 Working with the MAPIFolder Object 450 Working with the Items Collection 459 Properties and Methods Common to Outlook Items 466 Outlook Issues 486 Conclusion 492 Chapter 12: Introduction to InfoPath 493 What Is InfoPath? 493 Getting Started 494 Form Security 499 Programming InfoPath 505 Data Source Events 509 Form Events, Properties, and Methods 518 Conclusion 529 Part III: Office Programming in VSTO 531 Chapter 13: The VSTO Programming Model 533 The VSTO Programming Model 533 VSTO Extensions to Word and Excel Objects 536 Dynamic Controls 542 Inspecting the Generated Code 549 VSTO Extensions to the Word and Excel Object Models 555 Conclusion 569 Chapter 14: Using Windows Forms in VSTO 571 Introduction 571 Adding Windows Forms Controls to Your Document 577 Writing Code Behind a Control 584 The Windows Forms Control Hosting Architecture 585 Properties Merged from OLEObject or OLEControl 594 Adding Controls at Runtime 597 Conclusion 605 Chapter 15: Working with the Actions Pane 607 Introduction to the Actions Pane 607 Working with the ActionsPane Control 613 Conclusion 628 Chapter 16: Working with Smart Tags in VSTO 629 Introduction to Smart Tags 629 Creating Document-Level Smart Tags with VSTO 633 Creating Application-Level Smart Tags 647 Conclusion 672 Chapter 17: VSTO Data Programming 673 Creating a Data-Bound Customized Spreadsheet with VSTO 673 Creating a Data-Bound Customized Word Document with VSTO 681 Datasets, Adapters, and Sources 682 Another Technique for Creating Data-Bound Spreadsheets 691 Caching Data in the Data Island 699 Advanced ADO.NET Data Binding: Looking Behind the Scenes 704 Binding-Related Extensions to Host Items and Host Controls 705 Conclusion 712 Chapter 18: Server Data Scenarios 713 Populating a Document with Data on the Server 713 Using ServerDocument and ASP.NET 716 A Handy Client-Side ServerDocument Utility 724 The ServerDocument Object Model 726 Conclusion 737 Chapter 19: .NET Code Security 739 Code-Access Security Versus Role-Based Security 740 Code-Access Security in .NET 741 Location, Location, Location 749 Strong Names 753 Publisher Certificates 761 Trusting the Document 765 Deploying Policy to User Machines 769 Conclusion 773 Chapter 20: Deployment 775 VSTO Prerequisites 776 Deploying to an Intranet Shared Directory or Web Site 777 Local Machine Deployment Without a Deployment Manifest 785 Editing Manifests 787 Creating Setup Packages 793 Conclusion 805 Part IV: Advanced Office Programming 807 Chapter 21: Working with XML in Excel 809 Introduction to Excel’s XML Features 809 Introduction to XML Schema Creation in Visual Studio 811 An End-to-End Scenario 816 Advanced XML Features in Excel 826 Excel-Friendly XML Schemas 830 VSTO Support for Excel Schema Mapping 833 Conclusion 849 Chapter 22: Working with XML in Word 851 Introduction to Word’s XML Features 851 An End-to-End Scenario: Creating a Schema and Mapping It into a Word Document 855 Exporting the Mapped XML in the Document to an XML Data File 869 Importing an XML Data File into the Mapped Document 871 The XML Options Dialog Box 877 VSTO Support for Word Schema Mapping 880 VSTO Support for the WordML File Format 888 Conclusion 889 Chapter 23: Developing COM Add-Ins for Word and Excel 891 Introduction to Add-Ins 891 Scenarios for Using Add-Ins 892 How a COM Add-In Is Registered 893 Implementing IDTExtensibility2 897 Writing a COM Add-In Using Visual Studio 904 The Pitfalls of mscoree.dll 914 COM Interop and regasm.exe 914 Shimming: A Solution to the Problems with mscoree.dll 919 Conclusion 920 Chapter 24: Creating Outlook Add-Ins with VSTO 921 Moving Away from COM Add-Ins 921 Creating an Outlook Add-In in VSTO 933 Conclusion 940 Bibliography 941 Index 943

Reviews

Author Information

Eric Carter is the development manager of the Visual Studio Tools for Office (VSTO) team at Microsoft. He helped invent, design, and implement many of the features that are in VSTO today. Previously at Microsoft he worked on Visual Studio for Applications, the Visual Studio Macros IDE, and Visual Basic for Applications for Office 2000 and Office 2003. Eric Lippert’s primary focus during his nine years at Microsoft has been on improving the lives of developers by designing and implementing useful programming languages and development tools. He has worked on the Windows Scripting family of technologies, Visual Studio Tools for Office and, most recently, the new Language Integrated Query features of C# 3.0.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions