OfficeDev/Excel-Add-in-JS-BabylonJS

Name: Excel-Add-in-JS-BabylonJS

Owner: Office Developer

Description: null

Created: 2015-10-07 16:17:50.0

Updated: 2017-11-03 23:14:43.0

Pushed: 2018-02-01 09:52:06.0

Homepage: null

Size: 2870

Language: JavaScript

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

Excel-Add-in-JS-BabylonJS

This is an Excel add-in that show how to deliver a great experience within a 3D scene for viewing Excel datas.

It is using http://www.babylonjs.com, a full JavaScript 3D engine.

In a Nutshell

This add-in takes all the datas from the current worksheet and inject them in the 3D BabylonJS Scene.

Every rows contains a position, and the associated position date & time.

The 3D scene produce a cool and smoothy pathfinding animation for each element, showing you how the people are moving into the Microsoft France lobby.

The sample is constructed with :

• Visual Studio 2015
• TypeScript
• Office.js SDK for add-in
• BabylonJS SDK

Try it out

Get the sample

Clone or download the sample, open it with Visual Studio 2015.

Please check in add in project if the start object is “Accueil.xls“.
This Excel file contains pre-populated datas, mandatory for the demo :

Hit F5 and try it !

Considerations

You will find the useful code in App/Welcome/Tracker.ts file :

• Function playDatas : get the rows from the Excel worksheet and create every animations.
• Function _setTableBinding : Create a binding using the addFromNamedItemAsync method.
• Function _createScene : Create the BabylonJS scene importing models, textures dans visuals assets.
• Function launchScene : Launch and render the scene. This method is called from the welcome.html page.
• Function resetDatas : Stop the animations, reset all positions and clean the scene.

This project has adopted the Microsoft Open Source Code of Conduct. For more information, see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.