Can the Excel Image function accept a "data" url as the source?

Question

Hello,

I'm currently developing a Javascript add-in for Excel.

During the development process, I have used both the addImage function to include images and the WebImage data type.

The current interaction of the code is using the WebImage data type. The code base has been extended so it can create images internally, unfortunately, the WebImage data type does not appear to support a base64 data URL as a source. Whilst I could use the addImage function to add the images to the document they won't be "in a cell" they are over in the shapes layer.

Is there any way of adding an image to the document and then "placing it in a cell".

Why not use "addImage"? Filtering in Excel whilst powerful doesn't always correctly filter the images associated with the shape layer, so often the images displayed are wrong for the row or some are left behind, place in cell avoids this problem.

So to reiterate my question is there a way to add and image from base64 data URL but still place the image in a cell (ie a WebImage)?

Kind regards

Johnny

Answer 1

Currently, Excel JavaScript API does not support directly inserting images from a base64 data URL into a cell as a WebImage. The WebImage data type is designed to support URLs of web-hosted images, and it does not handle base64 data URLs.

However, there is a workaround that involves using the addImage function to insert the image and then adjusting its position and size to make it appear as if it is inside a cell.