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

In This Topic

Initializes a new instance of an XLPictureShape.

Syntax

Visual Basic
C#

'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;

Reference

XLPictureShape Class
XLPictureShape Members
Overload List