XLPictureShape Constructor(WriteableBitmap,Int32,Int32,Int32,Int32)

Initializes a new instance of an XLPictureShape.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal img As System.Windows.Media.Imaging.WriteableBitmap, _
   ByVal x As System.Integer, _
   ByVal y As System.Integer, _
   ByVal width As System.Integer, _
   ByVal height As System.Integer _
)

public XLPictureShape( 
   System.Windows.Media.Imaging.WriteableBitmap 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;

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

XLPictureShape Class
XLPictureShape Members
Overload List