C1.Xaml.Excel Assembly > C1.Xaml.Excel Namespace > XLPictureShape Class > XLPictureShape Constructor : XLPictureShape Constructor(WriteableBitmap,Int32,Int32,Int32,Int32) |
'Declaration Public Function New( _ ByVal img As Windows.UI.Xaml.Media.Imaging.WriteableBitmap, _ ByVal x As System.Integer, _ ByVal y As System.Integer, _ ByVal width As System.Integer, _ ByVal height As System.Integer _ )
'Usage Dim img As Windows.UI.Xaml.Media.Imaging.WriteableBitmap Dim x As System.Integer Dim y As System.Integer Dim width As System.Integer Dim height As System.Integer Dim instance As New XLPictureShape(img, x, y, width, height)
// 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;