Connecting to SharePoint from an Office App

I’m frequently asked by developers how to connect to SharePoint from an App for Office. There are several ways to accomplish this, so I thought I’d document the patterns I’ve used. I’ll detail five patterns: Explicit Login SharePoint-hosted Office App App-only Permissions Permissions “on the fly” Office 365 APIs Apps for Office typically lack user…

7

Using Apps for Excel for Custom Data Access and Reporting

Microsoft Excel is known for being the #1 tool in the world for business intelligence and reporting. Regardless of what format insights are delivered, users often desire the ability to export and work with data in Excel. For that reason, Excel plug-ins are incredibly popular for custom and proprietary data access. Unfortunately, traditional plug-ins can…

3