Previous Page
Next Page

Book Cover
Visual Studio Tools for Office: Using C# with Excel, Word, Outlook, and InfoPath
By Eric Carter, Eric Lippert
...............................................
Publisher: Addison Wesley Professional
Pub Date: September 08, 2005
ISBN: 0-321-33488-4
Pages: 1008
 



Table of Contents  | Index

   Copyright
   Praise for Visual Studio Tools for Office
   Microsoft .NET Development Series
      Titles in the Series
   About the Authors
   Foreword
   Preface
   Acknowledgments
   Part One.  An Introduction to VSTO
          Chapter 1.  An Introduction to Office Programming
      Why Office Programming?
      Office Object Models
      Properties, Methods, and Events
      The Office Primary Interop Assemblies (PIAs)
      Conclusion
          Chapter 2.  Introduction to Office Solutions
      The Three Basic Patterns of Office Solutions
      Office Automation Executables
      Office Add-Ins
      Code Behind a Document
      Conclusion
   Part Two.  Office Programming in .NET
          Chapter 3.  Programming Excel
      Ways to Customize Excel
      Programming User-Defined Functions
      Introduction to the Excel Object Model
      Conclusion
          Chapter 4.  Working with Excel Events
      Events in the Excel Object Model
      Events in Visual Studio 2005 Tools for Office
      Conclusion
          Chapter 5.  Working with Excel Objects
      Working with the Application Object
      Working with the Workbooks Collection
      Working with the Workbook Object
      Working with the Worksheets, Charts, and Sheets Collections
      Working with Document Properties
      Working with the Windows Collections
      Working with the Window Object
      Working with the Names Collection and Name Object
      Working with the Worksheet Object
      Working with the Range Object
      Special Excel Issues
      Conclusion
          Chapter 6.  Programming Word
      Ways to Customize Word
      Programming Research Services
      Introduction to the Word Object Model
      Conclusion
          Chapter 7.  Working with Word Events
      Events in the Word Object Model
      Events in Visual Studio Tools for Office
      Conclusion
          Chapter 8.  Working with Word Objects
      Working with the Application Object
      Working with the Dialog Object
      Working with Windows
      Working with Templates
      Working with Documents
      Working with a Document
      Working with the Range Object
      Working with Bookmarks
      Working with Tables
      Conclusion
          Chapter 9.  Programming Outlook
      Ways to Customize Outlook
      Introduction to the Outlook Object Model
      Introduction to the Collaboration Data Objects
      Conclusion
          Chapter 10.  Working with Outlook Events
      Events in the Outlook Object Model
      Application-Level Events
      Outlook Item Events
      Other Events
      Conclusion
          Chapter 11.  Working with Outlook Objects
      Working with the Application Object
      Working with the Explorers and Inspectors Collections
      Working with the Explorer Object
      Working with the Inspector Object
      Working with the NameSpace Object
      Working with the MAPIFolder Object
      Working with the Items Collection
      Properties and Methods Common to Outlook Items
      Outlook Issues
      Conclusion
          Chapter 12.  Introduction to InfoPath
      What Is InfoPath?
      Getting Started
      Form Security
      Programming InfoPath
      Data Source Events
      Form Events, Properties, and Methods
      Conclusion
   Part Three.  Office Programming in VSTO
          Chapter 13.  The VSTO Programming Model
      The VSTO Programming Model
      VSTO Extensions to Word and Excel Objects
      Dynamic Controls
      Advanced Topic: Dynamic Host Items
      Advanced Topic: Inspecting the Generated Code
      VSTO Extensions to the Word and Excel Object Models
      Conclusion
          Chapter 14.  Using Windows Forms in VSTO
      Introduction
      Adding Windows Forms Controls to Your Document
      Writing Code Behind a Control
      The Windows Forms Control Hosting Architecture
      Properties Merged from OLEObject or OLEControl
      Adding Controls at Runtime
      Conclusion
          Chapter 15.  Working with Actions Pane
      Introduction to the Actions Pane
      Working with the ActionsPane Control
      Conclusion
          Chapter 16.  Working with Smart Tags in VSTO
      Introduction to Smart Tags
      Creating Document-Level Smart Tags with VSTO
      Creating Application-Level Smart Tags
      Conclusion
          Chapter 17.  VSTO Data Programming
      Creating a Data-Bound Customized Spreadsheet with VSTO
      Creating a Data-Bound Customized Word Document with VSTO
      Datasets, Adapters, and Sources
      Another Technique for Creating Data-Bound Spreadsheets
      Caching Data in the Data Island
      Advanced ADO.NET Data Binding: Looking Behind the Scenes
      Binding-Related Extensions to Host Items and Host Controls
      Conclusion
          Chapter 18.  Server Data Scenarios
      Populating a Document with Data on the Server
      Using ServerDocument and ASP.NET
      A Handy Client-Side ServerDocument Utility
      The ServerDocument Object Model
      Conclusion
          Chapter 19.  .NET Code Security
      Code Access Security Versus Role-Based Security
      Code Access Security in .NET
      Location, Location, Location
      Strong Names
      Publisher Certificates
      Trusting the Document
      Deploying Policy to User Machines
      Conclusion
          Chapter 20.  Deployment
      VSTO Prerequisites
      Deploying to an Intranet Shared Directory or Web Site
      Local Machine Deployment Without a Deployment Manifest
      Editing Manifests
      Creating Setup Packages
      Advanced Topic: Deploying Network Solutions to Be Cached Locally
      Conclusion
   Part Four.  Advanced Office Programming
          Chapter 21.  Working with XML in Excel
      Introduction to Excel's XML Features
      Introduction to XML Schema Creation in Visual Studio
      An End-to-End Scenario
      Advanced XML Features in Excel
      Excel-Friendly XML Schemas
      VSTO Support for Excel Schema Mapping
      Conclusion
          Chapter 22.  Working with XML in Word
      Introduction to Word's XML Features
      An End-to-End Scenario: Creating a Schema and Mapping It into a Word Document
      Exporting the Mapped XML in the Document to an XML Data File
      Importing an XML Data File into the Mapped Document
      The XML Options Dialog
      VSTO Support for Word Schema Mapping
      VSTO Support for the WordML File Format
      Conclusion
          Chapter 23.  Developing COM Add-Ins for Word and Excel
      Introduction to Add-Ins
      Scenarios for Using Add-Ins
      How a COM Add-In Is Registered
      Implementing IDTExtensibility2
      Writing a COM Add-In Using Visual Studio
      The Pitfalls of MsCoree.dll
      COM Interop and Regasm.exe
      Shimming: A Solution to the Problems with MsCoree.dll
      Conclusion
          Chapter 24.  Creating Outlook Add-Ins with VSTO
      Moving Away from COM Add-Ins
      Creating an Outlook Add-In in VSTO
      Conclusion
   Index

Previous Page
Next Page