serverclient browser host web server host sharepoint exchange office app client apis server apis...
DESCRIPTION
ServerClient Browser Host Web Server Host SharePoint & Exchange Office APP Client APIs Server APIs Other Devices & Clients 3 rd Party ServicesTRANSCRIPT
Creating apps for Excel, Word and PowerPointRolando JimenezLead Program Manager
SPC046
ServerClient
Brow
ser H
ost
Common App ArchitectureWeb Server HostClient-side Logic
HTML / CSS / Javascript
Office JS SharePoint JS (CSOM)
SharePoint&
Exchange
Server-side LogicAny language
Office
Web
App
s
WinR
T
Mac
Mobil
e
Win3
2
APP Provider-hosted
Othe
rE.g
. LAM
P
IIS /
ASP.N
et
Wind
ows
Azur
e
CSOM REST
On-premises
IE
Chro
me
FireF
ox
Safar
i
Tier 1 Tier 2
OtherECMAScript 5
Online
SharePoint
SQL
Workflow
Autohosted
SQL
Web Sites
Clien
t APIs Server
APIsOthe
r Dev
ices
& Cli
ents
3rd Pa
rty Se
rvice
s
Development ToolsVisual Studio 2012, Napa or any standard Web development tool
ServerClient
Brow
ser H
ost
Common App ArchitectureWeb Server Host
SharePoint JS (CSOM)
SharePoint&
Exchange
Server-side LogicAny language
APP Provider-hosted
Othe
rE.g
. LAM
P
IIS /
ASP.N
et
Wind
ows
Azur
e
CSOM REST
On-premises
IE
Chro
me
FireF
ox
Safar
i
Tier 1 Tier 2
OtherECMAScript 5
Online
SharePoint
SQL
Workflow
Autohosted
SQL
Web Sites
Clien
t APIs Server
APIsOthe
r Dev
ices
& Cli
ents
3rd Pa
rty Se
rvice
s
Office JS
Office
Web
App
s
WinR
T
Mac
Mobil
e
Win3
2
Client-side LogicHTML / CSS / Javascript
Development ToolsVisual Studio 2012, Napa or any standard Web development tool
Apps for Office - Recap
App
App ManifestWeb Page<XML>HTML/CSS/JS
• 3 Shapes
• Multi-platform & Cross AppExcel (Web / Desktop) Outlook (Web / Desktop / Mobile Web) Word (Desktop) PowerPoint (Desktop) Project (Desktop)
• Javascript API• Run-time Sandbox
Apps for Office - Recap
• Cross Platform• Designed from the ground up, Abstraction, Async
• Cross App• Common objects and methods across apps (selection, tables, settings)
• Compatibility• Office Version to Version
• Web Standards• ECMAScript 5 E.g. Property get/set, strict mode; Plain JS objects
• Performance• Async, limits
Principles
Office Javascript API Overview
Document
Office.context
CustomXmlParts
Bindings
Settings
R/W Selection
Mailbox
Properties & Settings
User Profile
EWS
Item
Project
Tasks
Project Info
Demos
Custom XML Parts
Custom XML Parts
word
_rels customXml
docProps
Content Types
Word file structure
Custom XML Parts in Office documentsIntroduced with Office 2007, documents can store islands of XML data, called a custom XML part within a document file.
The TimeSummary document shown on the left contains a custom XML part containing time and billing data.
Content Control Binding to parts
word
_rels customXml
docProps
Content Types
Word file structure
Word Content ControlsIntroduced with Office 2007, content controls act as containers for specific kinds of content. Content controls can be mapped to nodes within a custom XML part.
New Repeating Section content controlA Repeating Section content control provides the capability to bind to a collection of nodes.
Content Controls mapped to custom XML part
• Operations apps can perform• Add/delete custom XML parts• Get XML parts• Get/set node values• Event handlers for node deleted, inserted, or replaces
• Core objects for working with custom XML parts• CustomXmlPart• CustomXmlParts• CustomXmlNode• CustomXmlPrefixMappings
Office.js support for CustomXmlParts
Custom Xml Parts Demo
Connecting to SharePoint
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
Thank you
Please eval this session at MySPC
Evaluate this session now on MySPC using your laptop or mobile device: http://myspc.sharepointconference.com
MySPC
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.