Spread.NET 17 Formula Reference
Formula Functions / Functions H to L / IMAGE
In This Topic
    IMAGE
    In This Topic

    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.

    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.