[]
DEMOS BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

IMAGE

The IMAGE function returns an image within a cell. The function inserts images into cells, instead of letting it float on top. This way you can move and resize cells, sort and filter, and work with images easily.

Syntax

=IMAGE(source,[alt_text],[sizing],[height],[width])

Arguments

The function has the following arguments:

Argument

Description

source

The location of the image on the web (Supported file formats include BMP, JPG/JPEG, GIF,TIFF, PNG, ICO, and WEBP)

alt_text

[optional] Alternative text that describes the image.

sizing

[optional] Specifies the image dimensions. Possible values are as follows: * 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

height

[optional] Refers to the height of the image only when sizing 3 option is used.

width

[optional] Refers to the width of the image only when sizing 3 option is used.

Data Types

The function returns an image.

Examples


Version Available

This function is available in product version 16.0 or later.

Spread for WinForms provides the GC.IMAGE function to place an image in a cell. For more information about GC.IMAGE function, refer to the Image Sparkline topic. You can also insert an image in a cell. To learn more about adding images in the cell, see Adding Image in a Cell topic.

!type=note

Note: The IMAGE function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.