XLPictureShape Constructor(WriteableBitmap,Rect)

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal img As Windows.UI.Xaml.Media.Imaging.WriteableBitmap, _
   ByVal rc As Windows.Foundation.Rect _
)

'Usage
 
Dim img As Windows.UI.Xaml.Media.Imaging.WriteableBitmap
Dim rc As Windows.Foundation.Rect
 
Dim instance As New XLPictureShape(img, rc)

public XLPictureShape( 
   Windows.UI.Xaml.Media.Imaging.WriteableBitmap img,
   Windows.Foundation.Rect rc
)

Parameters

img: The image contained in the new XLPictureShape.
rc: The rectangle that specifies the image size and position with respect to the cell, in twips.

The code below adds an image to a cell. The image is drawn within a rectangle centered on a cell with a 60 twip edge around it:

C#

// get sheet and cell
XLSheet sheet = c1ExcelBook1.Sheets[0];
XLCell  cell  = sheet[row, col];
            
// calculate cell size to align picture
Rectangle rc = new Rectangle(0, 0
    sheet.Columns[col].Width, 
    sheet.Rows[row].Height);
            
// add 60 twip edge
rc.Inflate(-60, -60);
            
// build XLPictureShape
XLPictureShape pic = new XLPictureShape(image, rc);
            
// assign XLPictureShape to cell
cell.Value = pic;

Reference

XLPictureShape Class
XLPictureShape Members
Overload List