The night before ng-conf 2015 started, there were a number of lightning talks and hack-night activities. You might be surprised to see Microsoft as part of the mix. With the lure of several Xbox Ones to give away, there ended up being 11 teams competing for the prizes. Josh Carroll and I represented “Team Wintellect”.
Our task was to take one of Andrew Connell’s starter projects:
https://github.com/andrewconnell/ngconf15-hackathon-outlook - which looks up names found in Outlook messages for matching customers.
https://github.com/andrewconnell/ngconf15-hackathon-excel - which adds products to an Excel spreadsheet to generate invoices.
And create our own project that demonstrates some interesting add-on functionality to one of these office apps.
Oh … and there was only two hours to complete it!
This is what we came up with, https://github.com/Wintellect/ng-office-graphs. I apologize up front for the (lack of) quality of this code, but we were successfully able to update data in the spreadsheet and draw the graph based on this data.
(I hope to revisit this code and clean it up. I also forgot to take a screen shot, which I’ll post later.)
The main integration code is below:
After the Office application initializes, we were able to prompt the user for a range of data (addFromPromptAsync) and then pull the data from the spreadsheet (getDataAsync). The rest was just drawing the D3 visualization.
Microsoft has created a nice extensibility interface for office apps and I’m interested to see what new kinds of add-ons will be created.
Also, thanks to Jeremy Thake, Andrew, and Microsoft for the event.
And for the Xbox One, too!