Office Development at //Build/ 2016 – 2 – Graph Changes

snip_20160419224647

Microsoft Graph is a gateway to data and insights in Office365 allowing you to easily traverse over objects and relationships to access the information that is sitting in the Office365 services using web standards. Microsoft Graph is an open platform accessible through a secure data access mechanism.

Microsoft Graph API developer stack.

At Build, with regards to Microsoft Graph the following changes have been announced for General Availability:

  • Webhooks on Outlook Entities
  • Access to consumer services OneDrive and Outlook.com
  • OneDrive large file upload/download

The following, but not only this – there is more, went in preview:

  • Excel REST API
  • Administrative Units
  • Find Meeting Time API
  • Get/set out of office
  • Online meeting links
  • Updates to People API
  • Updates to trending APIs

Documentation on Microsoft Graph can be found at:

Microsoft Graph: The easiest way to call

Happy wishes and some Office predictions for 2016

MVP_Horizontal_FullColor

Another year has gone, a new year started … this is 2016. Welcome!

My year, for the eleventh time already, started with receiving the Microsoft Most Valuable Professional (MVP) Award again.

After nine years of receiving the award for Visual Studio Tools for the Office System (VSTO), one year of Office365 I now, after the award update, received the award in the award category “Office Servers and Services”. This is where all former Office365, Exchange, SharePoint, Skype for Business and Yammer are grouped today. As of October 2015 the MVP Award categories have changed, there are now less categories and in theory you can get the MVP Award in multiple categories.

So what will bring 2016 to you and me? Well nobody knows… so I don’t know either, but let’s see if we can make some educated guesses here.

2015 was the year Office Microsoft released some early updates on the Office 365 APIs. Starting with the outer ring of Office365 we got access to files, contacts and much more. Access to the documents itself (the structure of the document, in VBA the Object Model) was fairly limited.

In 2016 I expect to see much more APIs providing access to the Office document model. This will give you the functionality, but now cross-platform, like you used to see with VBA, COM-Addins and in VSTA/VSTO solutions.

Let’s see how the Office365 APIs progresses in the year of 2016. Join me in the process of learning the ‘modern’ ways of developing Office solutions on x-plat. Keep an eye on my blog …

Office JS Public Preview is here!

Office365DevPodcastLogo_01

After months, years maybe, it is finally here: The new cross-platform Excel and Word JavaScript API’s in Public Preview!

Up to now the development of this was happening behind the screen, not available for the general public. At first with little snippets, test scenarios and try-outs to find the best way to work with this, not only on Windows platforms but also the other platforms like iOS or Android.

Until now the Office JS API’s were mostly limited to Office365 interfaces but not targeting file content. This now is changed, at least for the first and still somewhat limited version.

What this means is that you now get the option to actually interact with the file contents. For now only on Excel en Word and only for a small subset of the Object Model as you know it from VBA and/or VSTO, but it is a start.

As its now open into the public, go ahead, and take a look at the public preview of Office.js API’s in Office 2016 and try some of the samples to get an impression on how this works:

Increase the productivity of Users’ with enhanced Office.js APIs in Office 2016

I will go into some more detail in future blog posts. Hopefully a start to get the full object model available but now on multiple platforms!

Back to Blogs … Installing Live Writer 2012

I lost my blogging tools in the process of testing Windows 10 and or reinstalling machines. I now finally came to install Live Writer back on my machine.

I am working on getting my way around Office365 Development. It appears that developing using VBA and VSTO Add-ins is soooo year 2000, time to move forward Winking smile.

Well, the real story is that in my day job I’m still on VSTO but it probably doesn’t come as a surprise if I say that Microsoft already spent at least four years (plus) by now on creating a new Add-in platform that is ready to target X-Platform (Windows, IOS, Android) development.

They still have a long way to go, many items within the current (COM) object model still needs to be addressed, but as time is moving forward the Office Development Team is making great progress in adding new features every day hopefully in the end getting in par with the VSTO capabilities. And let’s be real, the Office365 scope of today is so much bigger than the scope of the ‘old’ Office.

Anyway, I got rebooted, and if you can read this I was able to get Live Writer 2012 installed and to be ready for future posts.

Oh, and this is how I installed Live Writer – in case you want to join me and start your own blog:

[Thanks to Stefan to help out here: http://blogs.technet.com/b/stefan_stranger/archive/2015/07/24/installing-windows-live-writer-on-windows-10.aspx]

New Office REST APIs and Developer Tools for Visual Studio Update

Tonight (here in Europe that is) Somasegar announced on his blog that the Visual Studio Team and the Office Team released a “number of significant updates for developers building apps that interact with the Office ecosystem”.

All of the updates are more or less related to building Apps for Office/SharePoint and the Cloud. If you need full integration (interacting between Word and Excel, building compound documents, Ribbon interaction etc.) I think you still need to use the ‘other’ option, VSTO. The downside of –that- however is that it won’t be as mobile a you’d like to see. You win some or lose some, depending on the technology you decide to use.

Back to the updates… Announced today were the new Office 365 APIs for consuming Office data and updates of Office Developer Tools for Visual Studio (not to be confused with Visual Studio Tools for the Office System aka VSTO, that is a complete other thing) and “Napa”.

Go and read the blogs for details on all of this,  no need for me to repeat all of it Glimlach

  • The Office 365 Platform blog
  • The Visual Studio blog
  • This year I’ll try to deep dive on this a bit more to get into the subject of replacing your current Add-ins with Apps for Office/SharePoint – Can you or can’t you? Where are we at the moment. Everyone wants to move their Add-ins into the Cloud, but is it even possible today? More on this later …

Showtime: Philomena

Philomena


The “Showtime” section on my blog is a reminder, mostly for my own reference but maybe helpful for other film enthusiasts as well, to remember what movies I’ve seen lately, what it was about and how I rated it in general.


Philomena is a movie nominated for 4 Oscars and a whole slew of other rewards. You wouldn’t expect that by just watching the trailer of the movie.

The movie is about a woman who got pregnant at a very young age and therefor was put away in a Catholic convent where her son was born. Shortly after that her son was taken away from her for adoption.

Journalist Martin Sixsmith started to follow Philomena’s story and together with Philomena he started their search for her long lost son who appeared to have been adopted by an American family. On the search they travel to the United States where they tried to find his current location.

The story of a mother searching for her son changed from a series of facts into an emotional piece of art where spectators in the audience had a hard time to keep it dry. In a silent moment you could hear a soft crying from all directions. The producer managed to touch the hearts of many with this drama. Nine out of Ten, highly recommended !