Excel for WPF | ComponentOne
C1.WPF.Excel Namespace / XLPictureShape Class / XLPictureShape Constructor / XLPictureShape Constructor(WriteableBitmap,Int32,Int32,Int32,Int32)
The image contained in the new XLPictureShape.
The horizontal position of the image with respect to the cell, in twips.
The vertical position of the image with respect to the cell, in twips.
The width of the image, in twips.
The height of the image, in twips.
Example

In This Topic
    XLPictureShape Constructor(WriteableBitmap,Int32,Int32,Int32,Int32)
    In This Topic
    Initializes a new instance of an XLPictureShape.
    Syntax
    'Declaration
     
    
    Public Function New( _
       ByVal img As WriteableBitmap, _
       ByVal x As Integer, _
       ByVal y As Integer, _
       ByVal width As Integer, _
       ByVal height As Integer _
    )
    public XLPictureShape( 
       WriteableBitmap img,
       int x,
       int y,
       int width,
       int height
    )

    Parameters

    img
    The image contained in the new XLPictureShape.
    x
    The horizontal position of the image with respect to the cell, in twips.
    y
    The vertical position of the image with respect to the cell, in twips.
    width
    The width of the image, in twips.
    height
    The height of the image, in twips.
    Example
    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:
    // 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.X, rc.Y, rc.Width, rc.Height);
                
    // assign XLPictureShape to cell
    cell.Value = pic;
    See Also