Rules+ | Formula RULEEXCELPICTURE
Description
This formula embeds images in an Excel file when a rule is fulfilled.
Formula(s)
PHP
{=EXCELPICTURE(MAM-ID(s);Width;Height;Excel width;Excel height;"Format";"Color space";Resolution;First only; "Rule ID or key")}Result
String
Parameters
Parameter | Contents | Format | Default value | Explanation |
|---|---|---|---|---|
MAM D(s) | Single MAM ID or an array of MAM 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 is used if an array with several is specified. |
Rule ID or key | Rule to be fulfilled | Rule ID: Integer Key: String | "" |
|