IMAGE function
Display an HTTPS image in a cell.
Return a picture with alternative text, using fit, fill, original or custom dimensions.
Syntax
IMAGE(source, [alt_text], [sizing], [height], [width])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| source | Yes | The URL path, using an "https" protocol, of the image file.A2 |
| alt_text | No | Alternative text that describes the image for accessibility."Product diagram" |
| sizing | No | 0 fits while preserving the aspect ratio; 1 fills the cell; 2 keeps the original size; 3 uses custom height, width or both.3 |
| height | No | The custom height of the image in pixels.100 |
| width | No | The custom width of the image in pixels.100 |
Put a picture in a formula result
Calculate IMAGE from editable source cells, then resize the preview cell. The original attached pictures load locally. Their reserved .invalid URLs identify the attached source; they are not live image hosts.
Fit keeps the source aspect ratio. Resizing the output cell changes the displayed picture size.
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.