Connecting Microsoft Excel 2016 to OTCStreaming Using Javascript API for Office
Introduced in Office 2013, Microsoft web add-ins are web applications running on a browser inside an Excel worksheet. There is nothing installed on the user’s machine, nothing to download, no update to manage, no firewall to configure. The user will just have to open a web connection using his OTCstreaming credentials.
Web add-ins work differently from Excel add-ins or COM add-ins. Most Excel veterans will be surprised. The web add-in does not provide a new function to be used in the user’s worksheets cells. The web add-in provides functions in a browser panel interacting with the Excel’s object models like writing data in a cell or a range. Web add-ins are similar to a VBA macro but they are written in JavaScript and are connected to the web. Being connected to the web, the add-in can use complex functions or services on a distant server. OTCStreaming web add-in downloads data from OTCStreaming’s database and subscribe to real time events available on OTCStreaming’s servers.
The OTCStreaming development team was pleased to just use JavaScript to develop a quick bridge between OTCStreaming and Microsoft Excel. Easy to implement, the technology works on Windows as well as on OS X operating systems. The team will keep releasing new features. The user should have the same UX in a browser or on his personal Office’s tools.
<< Back to articles list