Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath

ISBN: 321334884
EAN: N/A

Year: N/A
Pages: 214

BUY ON AMAZON

Part One. An Introduction to VSTO

• Part One. An Introduction to VSTO

An Introduction to Office Programming

• Why Office Programming?
• Office Object Models
• Properties, Methods, and Events
• The Office Primary Interop Assemblies (PIAs)
• Conclusion

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

• Part Two. Office Programming in .NET

Programming Excel

• Ways to Customize Excel
• Programming User-Defined Functions
• Introduction to the Excel Object Model
• Conclusion

Working with Excel Events

• Events in the Excel Object Model
• Events in Visual Studio 2005 Tools for Office
• Conclusion

Working with Excel Objects

• 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

Programming Word

• Ways to Customize Word
• Programming Research Services
• Introduction to the Word Object Model
• Conclusion

Working with Word Events

• Events in the Word Object Model
• Events in Visual Studio Tools for Office
• Conclusion

Working with Word Objects

• 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

Programming Outlook

• Ways to Customize Outlook
• Introduction to the Outlook Object Model
• Introduction to the Collaboration Data Objects
• Conclusion

Working with Outlook Events

• Events in the Outlook Object Model
• Application-Level Events
• Outlook Item Events
• Other Events
• Conclusion

Working with Outlook Objects

• 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

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

• Part Three. Office Programming in VSTO

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

Using Windows Forms in VSTO

• 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

Working with Actions Pane

• Introduction to the Actions Pane
• Working with the ActionsPane Control
• Conclusion

Working with Smart Tags in VSTO

• Introduction to Smart Tags
• Creating Document-Level Smart Tags with VSTO
• Creating Application-Level Smart Tags
• Conclusion

VSTO Data Programming

• 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

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

.NET Code Security

• .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

Deployment

• 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

• Part Four. Advanced Office Programming

Working with XML in Excel

• Introduction to Excels 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

Working with XML in Word

• Introduction to Words 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

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

Creating Outlook Add-Ins with VSTO

• Moving Away from COM Add-Ins
• Creating an Outlook Add-In in VSTO
• Conclusion