Stringfunctions+ | Formula EXCELPICTURE
Description
This formula embeds images into an Excel file.
Formula(s)
PHP
{=EXCELPICTURE(DAM ID(s);Width;Height;Excel width;Excel height;"Format";"Color space";Resolution;First only)}Result
String
Parameters
Parameter | Content | Format | Default value | Explanation |
|---|---|---|---|---|
DAM ID(s) | Single DAM ID or an array of DAM IDs | Integer Array |
|
|
Width | Image width | Integer |
|
|
Height | Image height | Integer |
|
|
Excel width | Excel width in mm | Integer |
|
|
Excel height | Excel height in mm | Integer |
|
|
Format | Image format | String | "PNG" |
|
Color space | Image color space | String | "rgb" |
|
Resolution | Image resolution | Integer | 72 |
|
First only | TRUE or FALSE | Boolean | FALSE | TRUE: Only the first image if an array with several is specified |