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