XLPictureShape Constructor(WriteableBitmap,Rect)

In This Topic

Initializes a new instance of an XLPictureShape.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal img As WriteableBitmap, _
   ByVal rc As Rect _
)

public XLPictureShape( 
   WriteableBitmap img,
   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;

Reference

XLPictureShape Class
XLPictureShape Members
Overload List