Hi everyone;

I need to add picture to spreedsheet as programmatically. I stored pics which user wanted on catalog, and I need write pics of users on spreedsheet as programmatically.

Ho can I do that?

Hello, Mehmet Tuğrul SARIÇİÇEK.

Please, see an example on the QR code page.

Thank you Timofey Bugaevsky,

I couldn't explain. I do not want to generate QRCode, I have already store pictures in a catalog object.

Here this catalog object.

And I get pictures via query use owner informations.

Attached Files

Download gömülüdosya.PNG (4.59 KB)

you need this part:

   SpreadsheetDocument = New SpreadsheetDocument;

   Template = GetCommonTemplate("QRCodeSample");
   Area = Template.GetArea("Output");

   Area.Drawings.QRCode.Picture = <picture object>;

   SpreadsheetDocument.Put(Area);

   Picture = New Picture(CatalogItem.Picture.Get());

Thank you so much Timofey Bugaevsky,

I solved like this, it's working well.

PictureFile   = PredefinedValue("Catalog.GömülüDosyalar.EmptyRef");
      PictureFile   = Sdr.TahliyePlanı;
      If Not PictureFile.IsEmpty() Then
         Picture = New Picture(PictureFile.FileData.Get());
         Page7.Drawings.TahliyePlanı.Picture      = Picture;
      EndIf;