CODEWITHSUNDEEP
javascriptexcelms-officeadd-in
Brian Stallter
Brian Stallter

Reputation: 159

Embedding excel in a webpage

I have read from Microsoft here that I can embed an excel sheet in a webpage. I have also read where I can embed a visio instance. Does anyone know if I can create a website that uses an excel instance and visio instance that is unique to each user's experience and draws from their custom database.

For example: say I have a pre-formatted excel sheet with fixed columns and I ask for the user to import their report card, and they do so. The database stores their report card information and outputs it to the excel spreadsheet instance.

Is this a possibility or can I only embed one single excel workbook that will be linked to the master and can not be customized for each user's experience of my webpage/web app?

It would be really cool if I could do the same with Visio as well. I have tried to find an exact answer to this, but I can not get a clearly defined differentiation of whether or not I can get unique instances, or whether all must be viewing the same master document.

Upvotes: 0

Views: 2209

Answers (1)

Nikolay
Nikolay

Reputation: 12245

You may need some non-free office server product to be able to do that (edit excel docs online). That can be SharePoint, OneDrive for Business (which is basically just another name for SharePoint), or Office Online server (the underlying technology).

Given that you have that in place, the rest is pretty easy - you can create a document per user, and just display it in IFRAME (you can google "WopiFrame" on how to do that exactly).

On the server, in principle, you can bind your Excel sheets to Visio drawings. So that when you edit the sheet, corresponding Visio drawing view is updated. Keep in mind, that is probably possible within a single SharePoint site.

Means, from M$ side, probably the assumed approach could be, you embed Excel and Visio frames in a web page, then embed that page into a SharePoint site, then host that on SharePoint online, and then pay for that on regular basis :)

If you don't want SharePoint, you can still go with Office Online to enable Excel editing in IFRAME on your own site; but here you'll loose Visio rendering, as it's only available in SP. And you'll need to build you own API. AFAIK, viewing office docs is free, editing is not (requires end-user office licensing). In case you would like to go this path, you could start over here: https://wopi.readthedocs.io/

Upvotes: 1

Related Questions