IMAGE function
Summary
Returns an image from a given source
Syntax
IMAGE(source, [alt_text], [sizing], [height], [width])
The IMAGE function takes the following arguments:
source The URL path, using an "https" protocol, of the image file. Required. Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and also WEBP (WEBP is unsupported on Web and Android).
alt_text Alternative text that describes the image for accessibility. Optional.
sizing Specifies the image dimensions. Optional. There are several possible values:
• 0 Fit the image in the cell and maintain its aspect ratio.
• 1 Fill the cell with the image and ignore its aspect ratio.
• 2 Maintain the original image size, which may exceed the cell boundary.
• 3 Customize the image size by using the height and width arguments.
height The custom height of the image in pixels. Optional.
width The custom width of the image in pixels. Optional.
(if only one of the arguments of height/width is specified, the aspect ratio of the image will be kept according to the provided argument)
source The URL path, using an "https" protocol, of the image file. Required. Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and also WEBP (WEBP is unsupported on Web and Android).
alt_text Alternative text that describes the image for accessibility. Optional.
sizing Specifies the image dimensions. Optional. There are several possible values:
• 0 Fit the image in the cell and maintain its aspect ratio.
• 1 Fill the cell with the image and ignore its aspect ratio.
• 2 Maintain the original image size, which may exceed the cell boundary.
• 3 Customize the image size by using the height and width arguments.
height The custom height of the image in pixels. Optional.
width The custom width of the image in pixels. Optional.
(if only one of the arguments of height/width is specified, the aspect ratio of the image will be kept according to the provided argument)
Example
=IMAGE("https://support.content.office.net/en-us/media/2d9e717a-0077-438f-8e5e-f85a1305d4ad.jpg", "Sphere")
=IMAGE(A2, B2, 0)
=IMAGE(A3, B3, 1)
=IMAGE(A2, B2, 3, 100, 200)
=IMAGE(A2, B2, 0)
=IMAGE(A3, B3, 1)
=IMAGE(A2, B2, 3, 100, 200)