[]
This function input an URL or a base64 string to show an image in cell.
IMAGE(source, [alt_text], [sizing], [height], [width], [clipX], [clipY], [clipHeight], [clipWidth], [vAlign], [hAlign])
Argument | Description |
|---|---|
source | [Required] The URL path, using an "https" protocol, of the image file. |
alt_text | [Optional] Alternative text that describes the image for accessibility. |
sizing | [Optional] Specifies the image dimensions. 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. The default value is 0. |
height | [Optional] The height of the image in pixels. |
width | [Optional] The width of the image in pixels. |
clipX | [Optional] The x-axis coordinate of the top left corner of the source image sub-rectangle to draw into the destination context. The default value is 0. |
clipY | [Optional] The y-axis coordinate of the top left corner of the source image sub-rectangle to draw into the destination context. The default value is 0. |
clipHeight | [Optional] The height of the source image sub-rectangle to draw into the destination context. The default value is the height of image. |
clipWidth | [Optional] The width of the source image sub-rectangle to draw into the destination context. The default value is the width of image. |
vAlign | [Optional] Vertical alignment of the image. 0 - Top 1 - Center 2 - Bottom The default value is 2 (bottom). |
hAlign | [Optional] Horizontal alignment of the image. 0 - Left 1 - Center 2 - Right The default value is 0 (left). |
IMAGE("https://upload.wikimedia.org/wikipedia/en/4/41/Flag.svg")