Extending Office 2007 Clients with the Visual Studio Tools for Office 2005, Second Edition - PowerPoint PPT Presentation

Loading...

PPT – Extending Office 2007 Clients with the Visual Studio Tools for Office 2005, Second Edition PowerPoint presentation | free to view - id: 142c91-YzY1O



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Extending Office 2007 Clients with the Visual Studio Tools for Office 2005, Second Edition

Description:

Brings Office development to the professional .NET developer with a clean ... Integration of Office clients into the VS. ... Backward-compatible with Office 2003 ... – PowerPoint PPT presentation

Number of Views:73
Avg rating:3.0/5.0
Slides: 35
Provided by: downloadM
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Extending Office 2007 Clients with the Visual Studio Tools for Office 2005, Second Edition


1
Extending Office 2007 Clients with the Visual
Studio Tools for Office 2005, Second Edition
  • Microsoft Belux MSDN Evening Session
  • December 6th, 2006
  • Patrick Tisseghem
  • patrick_at_u2u.net

2
Whats on the menu?
  • What is VSTO SE all about?
  • Creating document-level automation solutions
  • Security, packaging and deploying
  • The new add-in architecture delivered with VSTO
  • Ribbon-extensibility with VSTO
  • Custom task panes with VSTO
  • Outlook form regions with VSTO
  • Whats next? VSTO 3.0 Orcas version
  • Drink

3
The 2007 Microsoft Office System
4
Development Tools for the Platform
5
What is VSTO?
  • Brings Office development to the professional
    .NET developer with a clean deployment and
    security story
  • Starting with VSTO 2005 (v2), developers have
  • Integration of Office clients into the VS.NET
    designer
  • .NET layers on top of the native object models
  • Possibility to use normal Windows controls
  • Simple and clean way of creating smart documents
    (programming against the document actions pane)
  • VSTO 2005 can NOT be used to automate Office 2007
    clients, but any VSTO 2005 solutions are can be
    upgraded without problems

6
What is VSTO 2005 Second Edition?
  • New product enabling easier, more efficient
    development of Microsoft .NET solutions for
  • The 2007 Microsoft Office system
  • Microsoft Office 2003
  • Intermediate step on the way to Orcas/VSTO v3
  • Provides early availability of some of the new
    features planned for Orcas, to facilitate Office
    2007 solution development today
  • Add-in extending Microsoft Visual Studio 2005
  • Microsoft Visual Studio 2005 Professional
    Edition
  • Microsoft Visual Studio Team System role-based
    editions
  • Visual Studio Tools for Microsoft Office
  • Available as a FREE, supported download at the
    same time as 2007 Microsoft Office
  • http//msdn.microsoft.com/office/tool/vsto/2005SE

7
What type of solutions can I build with VSTO 2005
SE?
  • Application-level automation
  • Replacing VBA with add-ins
  • Six applications in the 2007 Microsoft Office
    system
  • Five in Microsoft Office 2003
  • Tools and enhanced APIs for customizing the
    Ribbon UI
  • Creating custom task panes in add-ins for 2007
    Microsoft Office applications that support
    these features
  • Support for creating Outlook form regions in
    add-ins for Outlook 2007.

8
What type of solutions can I NOT build with VSTO
2005 SE
  • Document-level solutions
  • Host controls
  • Windows controls
  • Document actions pane
  • For this youll have to wait for VSTO 3.0 Orcas
    version
  • Intermediate solution
  • Build VSTO 2005 solutions with Office 2003 and
    port them to Office 2007

9
Primary Interop Assemblies
Office 2007
COM API
PIA
.NET Solution
  • Office 2003
  • PIA redistributable is available as a download
  • Office 2007
  • PIAs continue to be the mechanism for writing
    managed code with Office
  • Except InfoPath with its new managed OM
  • Backward-compatible with Office 2003
  • Managed applications built for Office 2003 will
    run without re-compile on Office 2007
  • PIAs will be available as a redistributable
    component

10
Converging Add-In Models
  • All major new extensibility features are
    implemented via add-ins
  • Custom task panes
  • Ribbon customization
  • Outlook custom form regions
  • etc
  • Standard QueryInterface/QueryService model
  • Different interfaces exposed in a consistent
    manner
  • Standard design-time experience
  • Office and VSTO work to define optimal interfaces
  • VSTO add-ins use a streamlined load path
  • Office knows more information about VSTO add-ins

11
New Runtime
  • Updated redistributable runtime for VSTO 2005 SE-
    and VSTO 2005-based solutions for
  • 2007 Microsoft Office system
  • Microsoft Office 2003 System
  • This new runtime is recommended even if you are
    still only using VSTO 2005-based solutions it
    is compatible.

c\Program Files\Common Files\Microsoft
Shared\VSTO\8.0\Microsoft.VisualStudio.Tools.Appl
ications.Runtime.dll
12
VSTO Add-Ins Why?
  • Robustness and scalability
  • Appdomain isolation
  • Disconnect unload
  • Strong typing
  • The VSTO add-in model becomes the standard for
    Office extensibility
  • A single standard model for multiple interfaces
  • Per-add-in disable/enable (blacklisting)
  • Fine-grained UI management
  • Deployment and security
  • Remote deployment capability
  • Automatic updates
  • Security chokepoint
  • Support for existing managed shared add-ins
  • VSTO design-time support
  • Project types, class templates, designers
    code-gen

13
Add-In Architecture
OfficeHost App
AddinLoader IDTExtensibility2 Adapter
AddinLoader IDTExtensibility2 Adapter
AddinLoader IDTExtensibility2Adapter
14
Add-Ins for 2007 Microsoft Office
15
DEMO
  • Bad add-ins versus good add-ins

16
Ribbon ComponentsReview
  • Ribbon accessible via a tab
  • A Ribbon contains one or more groups
  • A group contains one or more controls
  • New controls ToggleButtons, SplitButtons,
    EditBoxes, DropDowns, ComboBoxes, CheckBoxes,
    DropDownGrids

17
How to Customize Ribbon UI
  • Add Ribbon support item to your project to
    pre-generate
  • Sample Ribbon XML file
  • Ribbon class definition with all the hookups
  • Uncomment the code as instructed, if you want to
    use the XML file
  • Modify Ribbon XML to add controls, as desired
  • Implement Ribbon callbacks in the Ribbon class
    definition

18
DEMO
  • Application-level custom ribbon

19
Custom Task Panes MDI vs. SDI
  • New custom task pane model not tied to the
    document file
  • But dependent on distinction between SDI and MDI

20
How to Program Custom Task Panes Excel and
PowerPoint (MDI)
  • Design a user control using standard Visual
    Studio 2005 form designer
  • Add single line of code inside ThisAddIn_Startup
    to create a task pane with the user control
  • CustomTaskPanes.Add(myUserControl, My
    Taskpane)

21
DEMO
  • Custom Task Pane

22
Ribbon and Task Pane Interaction
  • Scenario I want a toggle button in the ribbon
    to control and reflect task pane visibility

23
How to Program Ribbon and Task Pane Interaction
  • Implement a custom task pane
  • Specify callback names in onAction and getPressed
    attributes inside your Ribbon XML
  • Implement Ribbon callbacks in your Ribbon class
  • inside onAction callback toggle task pane
    visibility
  • inside getPressed callback return control
    state based on taskpane visibility
  • Expose InvalidateControl method in your Ribbon
    class
  • Call InvalidateControl inside CustomTaskPanes
    VisibleChanged event handler

24
DEMO
  • Ribbon and Task Pane Interaction

25
Extending Outlook 2007
  • Simpler and cleaner development story because of
  • Consolidated object model
  • Better security model
  • Internal re-architecting to improve performance
  • New approach to create and deliver custom forms
  • Extensions to object model to access new Outlook
    2007 features

26
Outlook Form Regions Solution
  • Additive UI enhances Outlooks built-in forms
  • Adjoining and Separate Regions for both custom
    and built-in forms
  • Regions are created in Outlook Forms Designer
  • Forms solution implemented via Add-in
  • Deployment via Windows registry

27
Controls For Forms
  • New Outlook controls added to toolbox
  • Category Strip and Button
  • Contact Photo
  • Electronic Business Card Preview
  • Scheduling Free/Busy
  • InfoBar
  • Date and Time Picker
  • Check, Option, Edit, Label, Frame (MSForms)
  • Outlook controls are themed
  • Controls continue to support databinding
  • Event support for controls

28
Form Region Types
29
DEMO
  • Creating Outlook Forms Regions

30
VSTO Orcas Feature Set
  • Includes everything in VSTO 2005 SE
  • Support for new Office XML file formats
  • Excel 2007 and Word 2007 document projects
  • Rebuilds everything in the document as data store
    parts
  • Word content control support
  • ServerDocument
  • ClickOnce deployment
  • Standard model, tools, administration
  • Simplified security model
  • Version independent white list

31
VSTO Orcas Feature Set
  • More application add-in projects
  • SharePoint Designer, Project, Publisher
  • More RAD design-time experiences
  • SharePoint Workflow projects
  • and more

32
Review
  • VSTO Hardcore .NET Development
  • When thinking add-ins for Office clients, think
    VSTO add-ins
  • Integrate, integrate, integrate
  • Office 2007 clients are extensible!
  • Better, cleaner story for developers
  • VSTO Orcas will provide a shared development
    environment for both Office clients and
    SharePoint developers

33
QUESTIONS?
  • patrick_at_u2u.net
  • tisseghemp_at_hotmail.com
  • http//blog.u2u.info/dottextweb/patrick

34
DRINK!
About PowerShow.com