Office as a development platform
Download
1 / 31

- PowerPoint PPT Presentation


  • 182 Views
  • Updated On :

Office as a Development Platform. Tim Heuer [email protected] http://timheuer.com/ 602-405-4567. That was then…. An Office Client Today…. An Office Client Today…. An Office Client Today….

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about '' - cassara


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Office as a development platform l.jpg

Office as a Development Platform

Tim Heuer

[email protected]

http://timheuer.com/

602-405-4567






Slide6 l.jpg

A unified solutions platform for building Office Business Applicationsthat make line-of-business systems, enterprisedata and workflows accessible and relevant to users.

Fully integrated Visual Studio Tools for Office technologies enable developers to build Office Business Applications and scalable enterprise grade solutions based on Microsoft Office.


Office business applications oba l.jpg
Office Business Applications (OBA)

  • New Breed of Applications

  • Use the Microsoft Office System to find and surface Line of Business Information

  • Composition point for the S+S vision

  • Pull through the entire stack

  • More info at http://www.microsoft.com/office/oba and http://msdn.microsoft.com/oba


Visual studio tools for office vsto l.jpg
Visual Studio Tools for Office (VSTO)

  • ServerDocument – manipulate documents without automating Office

  • Word content control support

    • Ribbon customization

    • Word content controls

    • Outlook form region customization

  • Document-level solutions

    • Word, Excel, InfoPath 2003 onwards

    • Managed controls on the doc surface

    • Doc-level Actions Pane

  • Application-level Add-ins

    • Appdomain isolation

    • Office 2003 & 2007 Office system apps

    • App-level custom task pane

  • Highly streamlined developer experience

    • New designers for ribbon and Outlook form region

    • VBA => VSTO interoperability

    • ClickOnce deployment and security

    • Support for Workflow and Microsoft SharePoint


Developer benefits l.jpg
Developer Benefits

RAD design experiencefor building Office-based apps

Utilize key2007 Office systemUI features

Streamlined tasks& processes

+

=

Build OBAs that leverage enterprise resources


Slide10 l.jpg


Ui customization in visual studio l.jpg
UI Customization in Visual Studio

  • Increased visual designer capability

  • Extended support for customizable task/action panes

  • Extended Outlook Form Region capabilities

  • Ribbon UI designer tools


Example office fluent ribbon extension l.jpg
Example: Office Fluent Ribbon Extension

Tab

Control

Group

Ribbon

Ribbon Designer

Ribbon

Controls

Design Surface


Ribbon ui customization l.jpg

demo

Ribbon UI Customization


Outlook form regions l.jpg
Outlook Form Regions

  • Visual Studio simplifies and speeds up Outlook form region design and configuration process with a visual designer and a wizard

    • Achieve maximum form region design flexibility with VS visual designer

    • Configure your form region with a simple, intuitive wizard

    • Run and Debug your form region right from VS (F5)

    • No need to manually handle manifest XML, OFS files, registry entries, etc.

    • Option to import Outlook-created OFS file

  • Implement a custom form region with an add-in



Outlook form regions16 l.jpg

demo

Outlook Form Regions


Word content controls l.jpg
Word Content Controls

  • New experience for developing structured documents in Word 2007

  • New UI for developers to access Word Content Controls

  • Programmable through Word Object Model

  • Support for XML Mapping

Toolbox

Controls


Custom task panes l.jpg
Custom Task Panes

  • Visual Studio 2008 provides app-level custom task panes

  • Create custom task panes with an add-in

  • Add-in support & task pane support for

    • Project, Excel, InfoPath, Outlook, PowerPoint, Word

  • Custom task panes appear in the main application window or (Outlook) inspectors

  • Populate custom task pane with UserControls

    • Populate user controls with Winform controls


Word content controls and task panes l.jpg

demo

Word Content Controlsand Task Panes


Much more l.jpg
Much more…

  • Smart Tags

  • SharePoint Workflow/WebParts

  • Office Communicator/Presence Integrations

  • Office Open XML

  • Excel Server

  • InfoPath


For more information l.jpg
For More Information

  • Cheat Sheets

    • MsoId - http://tinyurl.com/24zd8u

    • OfficeImageId - http://tinyurl.com/29dljb

  • OBA Central

    • www.obacentral.com

  • OBA for Architects

    • http://msdn2.microsoft.com/en-us/architecture/aa699381.aspx

  • OBA Dev Center

    • http://msdn2.microsoft.com/en-us/office/aa905528.aspx



Sharepoint workflow support l.jpg
SharePoint Workflow Support

  • Visual Studio 2008 supports creation of SharePoint workflow to help manage business process and information flow

    • Reduces complexity and greatly speeds development of SharePoint workflow


Vsto design time stack l.jpg
VSTO Design-time Stack

Microsoft Office Excel®, and Word

Excel,

InfoPath,

Outlook®,

PowerPoint®, Visio, Word, (Access, Project)

Microsoft SharePoint® Server 2007

Visual Studio

Excel,

Outlook,

PowerPoint, Word, (Access)

Excel,

Outlook,

PowerPoint, Word, (Access)

Office

IDE Hosting

Outlook

Workflow

Document

Solutions

Add-ins

Ribbon

Ribbon XML

Form Regions

Project Templates

Item Wizards

Visual Studio


Vsto runtime stack l.jpg
VSTO Runtime Stack

Microsoft Office Client Host

Doc-Level Solution

App-Level Add-in

VSTO Runtime

Doc Task Pane

Host Item

Controls

Windows Forms

Controls

Custom Ribbon

Custom Task Pane

Custom Form Region

Common VSTO/A Runtime

AppDomain Management

Security Enforcement

Deployment and Updating

.NET CLR

Managed Add-in Framework (MAF)

ClickOnce


Deployment security l.jpg
Deployment & Security

  • ClickOnce support

  • Complete end-to-end customization installation experience

    • Install from CD, removable drive storage, the web or network shares.

  • Richer version-independent security model

    • No longer reliant on CASPOL

  • Offline access via the ClickOnce Cache

    • Supports both web deployments and network shares


Clickonce l.jpg
ClickOnce

  • Low-impact deployment mechanism

    • Self-contained

    • Solutions installed per user

  • Prerequisites are installed if the user is an admin

  • Supports solution update / rollback without user intervention

  • Offline availability of solution


Security l.jpg
Security

  • Customization

    • No longer use ‘CASPOL’

    • Version-independent ClickOnce model

      • Works with future versions of .NET, VSTO Runtime & Office

    • Security evaluated on the deployment manifest

      • Check if the Deployment Manifest URL is in the IE Restricted sites

      • Evaluate certificate used to sign the deployment manifest

      • Consult the inclusion list

      • Security evaluated on installs & updates

  • Documents

    • Office 2007 Trusted Folder List

    • Customization still needs to be trusted


Custom task panes mdi vs sdi l.jpg
Custom Task Panes: MDI vs. SDI

  • New custom task pane model not tied to the document

  • Its behavior is dependent upon the distinction between MDI and SDI


Vba managed code interoperability l.jpg
VBA & Managed Code Interoperability

  • VBA can now call managed code with IntelliSense

  • This feature works for Word and Excel in Office 2007

  • Preserves the investment in VBA

  • Enables incremental extension of VBA solutions using VB or C#

  • Brings the power of .NET to your VBA solutions


Call managed code from vba l.jpg
Call Managed Code from VBA

  • Developers enable VBA via COM Interop

  • Interop implemented at design time

  • Developers can then call managed code from VBA with IntelliSense after building the project


ad