Apps for OfficeJoris PoelmansSharePoint ArchitectRealDolmen

About meWork at RealDolmen

Responsible for SharePoint Competence Center

SharePoint Server MVP since 2005

Active in Belux Information Worker User Group – www.biwug.be

Blog: http://jopx.blogspot.com

Twitter: @jopxtwits

Apps for Office and SharePoint

3

Apps

App catalog and store

Vacation request

Event planning

Expense calculator

Learning management

Risk management

Help-desksupport

Products and platforms

Services and data

4

Types of Office Apps

Task Pane App Content App Mail App

• Assist user working with one or more documents

• Works in Word,Excel, PowerPoint and Project

• Adds embedded content/functionality to documents

• Only in Excel and Excel web app

• Extends message and appointments with custom UI and behavior

• Used in Outlook and Outlook Web App

5

Anatomy of an Office AppEach App for Office is based on XML-based manifest• Points to a web page• Defines the type of the App for Office• Defines which Office applications it supports• Defines required capabilities

6

Principles of Office AppsCross PlatformDesigned from the ground up, Abstraction, Async

Cross AppCommon objects and methods across apps (selection, tables, settings)

CompatibilityOffice Version to Version

Web StandardsECMAScript 5 E.g. Property get/set, strict mode; Plain JS objects

PerformanceAsync, limits

7

Supported applicationsOffice client Office Web Apps

Task Pane App Word, PowerPoint, Excel, Project Excel Web App

Content App Excel Excel Web App

Mail App(1) Outlook Outlook Web App

(1) Exchange 2013 required, no IMAP/POP3 support

8

Office Javascript API Overview

Document

Office.context

CustomXmlParts

Bindings

Settings

R/W Selection

Mailbox

Properties & Settings

User Profile

EWS

Item

Project

Tasks

Project Info

9

Publication to App Catalog• App for Office distribution/deployment model based

on App Catalogs• Apps for Office are published by uploading its

manifest to an App Catalog• Different App Catalogs• Office Store• SharePoint App Catalog• File share App Catalog• Exchange 2013 App Catalog (mail apps only)

10

Functional Areas vs App Support SummaryFunctional area

Word Excel/Excel WAC PowerPoint Outlook/OWA Project

Get/Set data as text, table, matrix

Settings

Get File

Bindings

Custom XML Parts

Html and OOXML

Mailbox

11

• Apps for SharePoint and Office Dev Center - http://msdn.microsoft.com/en-US/office/apps

• Apps for SharePoint and Office Blog - http://blogs.msdn.com/b/officeapps/

• http://blogs.msdn.com/b/cesardelatorre/

• Office Store - http://office.microsoft.com/en-us/store/apps-for-excel-FX102804981.aspx

• Channel 9 video – Building Apps for Office and SharePoint 2013 - http://channel9.msdn.com/Events/Build/2012/3-020

Resources

Thank You