Add image to spreadsheet

[Berezkin Gena]

After executed Spreadsheet.Open() function, pictures are not displayed.

v. 14.345.0.0.49

An example is attached to the subject.

Attachment: TestInsertJPG_d63c980f.rar

[Kanimozhi Bharathi]

Hi Berezkin Gena, 

You need to add the images in SpreadsheetGrid Loaded Event. We have modified the sample based on your requirement. Please find the link below, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/TestAddPicture1057136094 

Regards 

Kanimozhi B 

[Berezkin Gena]

Thank you. It's work.

But I can't set position image. Image always has position Row= 5, Column=5. How I can set position for Image?

[Kanimozhi Bharathi]

Hi Berezkin Gena, 

 

You can position an image in spreadsheet by adjusting the Top and Left position of the ShapeImpl with change in row and column position. Please find the code example for your reference, 

 

var shape = spreadsheetControl.AddImage(worksheet, new RowColumnIndex(5, 8), stream); 

 

// Re-Positioning Picture 

shape.Top = 500; 

shape.Left = 500; 

 

  

Regards 

Kanimozhi B