The book is intended as a practical guide to developing applications for the Office system. The book will cover the Microsoft Office Excel and Word API to include the Pivot and Chart components that form part of the Excel API. The book targets the working developer tasked with building applications that leverage Microsoft Office technology. The book will focus on explaining core concepts thru working examples. Each example will be a solution to a common programming requirement for applications that are built to harness Office technology.
The book will make the assumption that the user is comfortable with .NET and Objected Oriented Programming. No attempt will be made to teach .NET. Instead, .NET will be used as a vehicle to drive Microsoft Office technology in applications. No attempt will be made to incorporate VBA style approaches. However, every attempt will be made to re-implement VBA style functionality using .NET. The intent is always to show that the .NET vehicle will provide a smoother ride and that the investment in this new paradigm is well worth the price of admission. The assumptions pay off for an intermediate to advanced level programming audience.
Some of the topics covered include:
- Excel components
- VSTO chart components
- VSTO Pivot Table components
- Customizing Excel with VSTO
- Word automation and manipulating Word documents
- Outlook automation
- Integrating email into office development
- Security
