ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLPictureShape Class / XLPictureShape Constructor / XLPictureShape Constructor(Image,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(Image,Int32,Int32,Int32,Int32)
    In This Topic
    Initializes a new instance of an XLPictureShape.
    Syntax
    'Declaration
     
    Public Function New( _
       ByVal img As GrapeCity.Documents.Drawing.Image, _
       ByVal x As System.Integer, _
       ByVal y As System.Integer, _
       ByVal width As System.Integer, _
       ByVal height As System.Integer _
    )
    public XLPictureShape( 
       GrapeCity.Documents.Drawing.Image img,
       System.int x,
       System.int y,
       System.int width,
       System.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