OfficeAdd-Ins

Specialthanks to our sponsors

Aboutme

PeterPlessers - peter.plessers@spikes.be

SharePointArchitectatSpikeshttp://www.spikes.be

Co-founderofTasksinaBoxhttp://tasksinabox.com

Agenda

� Whataremyoptions?� OfficeAdd-Ins� TaskAdd-Ins� ContentAdd-Ins� CommandAdd-Ins� MailAdd-Ins

� OfficeUIFabric� Lessonslearnedthehardway

VisualBasicforApplications

VisualStudioToolsforOffice

OfficeAdd-Ins

OfficeAdd-Ins VSTO VBA

Automations& Interactionwithhostcomputer a a

UserInterfaceCustomizations Partial a Partial

InteractionwithOfficeAPIs Partial a a

OfflineAvailability (HTML5capabilities) a a

Support forteamdevelopment+sourcecontrol a a

Runcodeatapplication-level a a

Sandboxedenvironment a

Compatibility Office2013+(Windows &Mac*)

OfficeOnlineMobile

Office2007+(Windows)

Office2000+(Windows&Mac*)

Applications OutlookWordExcel

PowerPointProject

OfficeMixAccessWebApps

OutlookWordExcel

PowerPointProjectVisio

InfoPath

OutlookWordExcel

PowerPointAccess

TypesofOfficeAdd-ins

Whereavailable?

Manifest+webpage=anappforOffice

TaskPaneAppUserExperience� FamiliarUserExperience� LeveragesfamiliarOfficeUIparadigm

� ReferenceInformation� Idealforprovidingreferenceinformationassociatedwithdocument.

Everythingyouneedtoeasilycreateandshareinteractiveonlinevideos

Appearinmessagesandappointments

Read&ComposeMode

Contextualtocurrentitem

DistributedbyExchange

ContextualActivationRules

ExtractedEntities

EntityType TextDetected

Address USpostaladdresses1MicrosoftWay,RedmondWA,98052

EmailAddress AnySMTPaddress

MeetingSuggestion AreferencetoaneventormeetingLet’smeet nextTuesdayforlunch.

Contact Apersonalnamerelated tootherentitiesRandyByrne,1MicrosoftWay,RedmondWA,98052

PhoneNumber UStelephone numbers(555)867-5309

TaskSuggestion Actionablesentences inan emailPleaseinstalloffice2013onmycomputer.

Url Afilenameorwebaddress

GetsubjectofselectedmailOffice.context.mailbox.item.subject J

GetattachmentsofselectedmailOffice.context.mailbox.item.attachments L

AccessingMailProperties

InAdd-In:1. GetacallbacktokenfromExchangeserver2. Callcustomwebservicepassingcallbacktoken+emailidIncustomwebservice:1. AuthenticatetoExchangeserverwithcallbacktoken2. CallEWStogetattachments foremail3. Returnresult

GetAttachments

• Getthesamelook&feelofnativeOfficeapplications

• CollectionofCSS,HTMLandJavaScript

• Features• Typography• ColorSchemes• Icons• Animations• ResponsiveGrid

OfficeUIFabric

Components

• Testinmultiplebrowsers/desktopapplications

• SecurityzonesinIEL

• Differencesincapabilities• E.g.,OutlookforMacdoesnotsupportAPIsforcomposemode

• EWSCallbackTokenBug!!!

LessonsLearned

Thankyou!