Excel Custom Function return WebImage not showing

61 Views Asked by At

I am trying Excel.WebImageCellValue interface in Excel Script Lab.

Here is my test code

/**
 * show image
 * @customfunction
 * @param {string} imagePath
 * @returns show image
 */
function meekouImage(imagePath) {
  return {
    type: "WebImage",
    address: imagePath
  };
}

But, it give different result for different image url.

If I test with =SCRIPTLAB.MEEKOUCDF.MEEKOUIMAGE("https://www.mrexcel.com/img/excel-tips/2021/11/create-a-personal-macro-workbook-sm.jpg"), it shows image correct in Excel Web.

If I test with =SCRIPTLAB.MEEKOUCDF.MEEKOUIMAGE("https://i.stack.imgur.com/hruDZ.jpg"), it will show empty in Excel cell.

Is there any limit for online url for WebImage?

0

There are 0 best solutions below