XLPictureShape Constructor(WriteableBitmap,Rect)

Initializes a new instance of an XLPictureShape.

Syntax

Visual Basic
C#

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

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

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);
            
// 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