Visual Studio Tools for Office: Using C# with Excel, Word, Outlook, and InfoPath [Electronic resources] نسخه متنی

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