//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; GrapeCity.Documents.Excel.Drawing.IShape shape = worksheet.Shapes.AddShape(GrapeCity.Documents.Excel.Drawing.AutoShapeType.Parallelogram, 20, 20, 200, 100); System.IO.Stream stream = this.GetResourceStream("logo.png"); shape.Fill.UserPicture(stream, GrapeCity.Documents.Excel.Drawing.ImageType.JPG); shape.PictureFormat.ColorType = GrapeCity.Documents.Excel.Drawing.PictureColorType.Grayscale; shape.PictureFormat.Brightness = 0.6; shape.PictureFormat.Contrast = 0.3; shape.PictureFormat.Crop.PictureOffsetX = 10; shape.PictureFormat.Crop.PictureOffsetY = -5; shape.PictureFormat.Crop.PictureWidth = 120; shape.PictureFormat.Crop.PictureHeight = 80; // Save to an excel file workbook.Save("ConfigShapeWithPictureFill.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim shape As IShape = worksheet.Shapes.AddShape(AutoShapeType.Parallelogram, 20, 20, 200, 100) Dim stream As IO.Stream = GetResourceStream("logo.png") shape.Fill.UserPicture(stream, ImageType.JPG) shape.PictureFormat.ColorType = PictureColorType.Grayscale shape.PictureFormat.Brightness = 0.6 shape.PictureFormat.Contrast = 0.3 shape.PictureFormat.Crop.PictureOffsetX = 10 shape.PictureFormat.Crop.PictureOffsetY = -5 shape.PictureFormat.Crop.PictureWidth = 120 shape.PictureFormat.Crop.PictureHeight = 80 ' save to an excel file workbook.Save("ConfigShapeWithPictureFill.xlsx")