Special Excel Issues
Conclusion
This chapter explored some of the most important objects in the Excel object model. We use many of these objects in the Excel examples in subsequent chapters. We also consider some additional Excel object model objects used to work with XML in Excel in Chapter 21, "Working with XML in Excel."
This chapter has described these objects as defined by the primary interop assemblies for Excel. You should be aware that VSTO extends some of these objects (Workbook, Worksheet, Range, Chart, ChartObject, and ListObject) to add some additional functionality such as data binding support. Part Three of this book examines those extensions.
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
Programming Excel
- Ways to Customize Excel
- Programming User-Defined Functions
- Introduction to the Excel Object Model
- Conclusion
Working with Excel Events
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
Working with Word Events
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
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
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
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
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
EAN: N/A
Pages: 214
