Drawing

«Drawing» – is a form's component that provides ability to place an image (pixel or vector) on the worksheet of resultant XLSX-file. In the tree of form structure, «Drawing» being located directly under «Pattern».

Properties tab:

Item «Area in the template»

The item is for binding of «Drawing» and the target area in the Excel-template. The target area for «Drawing» can only be within borders of the the upper-level «Pattern». In the Printing form (at runtime), the drawing will be placed directly into specified area, using resizing, if required.

For binding, You have to perform next steps successively:


  • select a required cells in the Excel-template, in which the drawing has to be placed;

  • press a button

located in the item «Area in the template».

Item «Size»

The item is for defining drawing size. Here is two modes:

  • Fit drawing within area, which defined in the previous item «Area in the template» ;

  • Get Width and Height dimensions of drawing from context field.

Here Top-Left corner of drawing is anchoring on Top-Left corner of area, which defined in the previous item «Area in the template». Width and Height dimensions of drawing are being transferred from specified context field. Dimensions must be specified in English Metric Units (or EMUs) (for example, default row height is approximally equal 200000 EMU) .

Item «Appearance at runtime»

By default, a Drawing is always appearing in the Printing form at runtime. But it is possible to dynamically define a presence of component in the Printing form.

The item is for binding the component appearance (in Printing form at runtime) to the any context field value (the Drawing will be output in the Printing form only if the specified context field is not initial).

You have to press a button "Pencil" and then in the popup search-help You have to choose required context field (so-called Appearance indicator):

If an Appearance indicator has character data type, You are able to set for analyzing just a part of string instead of entire string.

To do that You have to press a button

and then on a popup window specify a start position and number of characters that should be analized:

Item «Source»

Source of drawing can be static or dynamic.

Static source of drawing

This is an any pixel image (Excel menu: Insert tab > Illustrations group > Picture), or vector drawing (Excel menu: Insert tab > Illustrations group > Shapes), located on the current worksheet of Excel-template.

To bond with the source, You have to press a button "Pencil" and then in the popup window of search-help You have to choose required drawing (located in the actual worksheet):

Dynamic source of drawing

This is any field from context, that has a type XSTRING (RAWSTRING). The chosen field should contain a rawdata of pixel image (.jpg / .png / .gif) as byte sequence.

To bond with the source, You have to press a button "Pencil" and then in the popup window of search-help You have to choose required field of the context: