Template and image field

FLX TMS FlexCel for VCL & FMX
1


I have a template to generate a xlsx,  there is a tag to load an image from a  blob field: ##dbTable##IMG_LOGO

But the image isn't load and the xlsx cell got this charaters:  䵂䴆

Is there a proper way to get the image loaded ?

I am using Delphi Berlin and Firebird  3,  IMG_LOGO  is a field  BLOB SUB_TYPE 0 SEGMENT SIZE 80.

Thanks
2

Hi,

To put an image you need to write the tag in the image name, not in a cell.

Looking at the style of the tag (##dbTable##IMG_LOGO instead of <#dbTable.IMG_LOGO> i think you are using FlexCel 3. If that is the case then you can find an example in
<FlexCel Install Folder>\TMSSoftware\FlexCelVCL\Demo\Delphi\Modules\20.Reports\80.Images And Comments

Look at the image there. It is named ##FISH##Graphic##JPEG

914×652 97.9 KB



In FlexCel 3, you need to tell FlexCel the image type, so that's why the tag should be ##dbTable##IMG_LOGO##PNG  or ##dbTable##IMG_LOGO##JPEG

For FlexCel 6 specifying the image type is not needed and you could just name the image <#dbTable.IMG_LOGO>. Also there are other options to size the image in FlexCel 6.

But in both cases you need to apply the tag to the image name, by inserting a dummy image, then selecting it, and changing its name. 
3

Hi,


It is working now.   

I have both v3 and v6 to keep old code running.

Maybe I should migrate the templates and use only Flexcel 6.

Thanks.