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)}
Result
-
String
Parameters
Parameter
|
Contents
|
Format
|
Default value
|
Explanation
|
|---|---|---|---|---|
|
MAM ID)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 |
ID or name of the rule to be fulfilled |
Rule ID: Integer External key: String |
"" |
|