google-sheets - 如何在Google表格中通过网址获取图片的宽度和高度

Question

我在Google表格中按网址列出了图片列表。图像位于远程服务器上。
我通过图像(URL)功能在工作表中获得了预览。

有没有一种方法可以通过公式或脚本来获取每一行中每个远程图像的宽度和高度？

Answer 1

查看Google社区文档，发现这个问题asked here with no apparent solution.

这并不是您要查找的内容，但是您可以使用IMAGE函数设置图像的尺寸。

IMAGE(url, [mode], [height], [width])

url - The URL of the image, including protocol (e.g. http://).

The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text. mode - [ OPTIONAL - 1 by default ] - The sizing mode for the image

1 resizes the image to fit inside the cell, maintaining aspect ratio.

2 stretches or compresses the image to fit inside the cell, ignoring aspect ratio.

3 leaves the image at original size, which may cause cropping.

4 allows the specification of a custom size.

Note that no mode causes the cell to be resized to fit the image.

height - [ OPTIONAL ] - The height of the image in pixels. mode must be set to 4 in order to set a custom height.

width - [ OPTIONAL ] - The width of the image in pixels. mode must be set to 4 in order to set a custom width.