Add Custom Visual in Excel

Question

Hi,I have created a custom visual using HTML-Javascript-CSS and I want to add this visual in Excel.As per my research, there are 2 ways this could be done:1) Using the Developer panel, add Microsoft Web Browser and configure it with the path to my file and some other fields.2) Make it an Add-in and use it by importing the configurable .XML file.I tried both of these but,1) The first one throws an error as, "Cannot add object", and I'm stuck there.2) I do not know how to add the .XML file to help me add my chart.I might be wrong with the options above. There might be a better way of doing this that I am unaware of.Anyway, I want some serious help to add my chart to the Excel sheet. A response with some proper documentation or example (if available) would be highly appreciated.Thank you.

jkpieterse · Answer

Given that you have already used HTML/CSS/JavaScript I suggest to consider creating an in-app office-js add-in. Here is info on how to get started: https://learn.microsoft.com/en-us/office/dev/add-ins/overview/office-add-ins

dipammodi · Answer

JKPieterse&nbsp;Is it anyhow possible using VBA?

jkpieterse · Answer

Anything is possible with VBA. But whether your solution is easily built using VBA, depends on the exact requirements.

ketanjani · Answer

JKPieterse&nbsp;Thank you for your response.I want to create a custom chart using VBA that I have created in an HTML file using d3.js. So is it really possible to get VBA to work with javascript or do I need to go for pure VBA structure and add shapes and all in order to create a custom chart?If VBA supports javascript could you please send me a document or example that might be useful?

jkpieterse · Answer

You can add a web browser control to a userform ad have that load the html file. But I suspect this might be better solved by creating an office-js add-in.

Forum Discussion

Add Custom Visual in Excel

5 Replies

Resources