//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; System.IO.Stream stream = this.GetResourceStream("logo.png"); GrapeCity.Documents.Excel.Drawing.IShape picture = worksheet.Shapes.AddPicture(stream, GrapeCity.Documents.Excel.Drawing.ImageType.PNG, 20, 20, 100, 100); //set picture size. picture.WidthInPixel = 700; picture.HeightInPixel = 120; //config picture layout. picture.Fill.Solid(); picture.Fill.Color.ObjectThemeColor = ThemeColor.Accent1; //delete picture. picture.Delete(); // Save to an excel file workbook.Save("DeletePicture.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim stream As IO.Stream = GetResourceStream("logo.png") Dim picture As IShape = worksheet.Shapes.AddPicture(stream, ImageType.PNG, 20, 20, 100, 100) 'set picture size. picture.WidthInPixel = 700 picture.HeightInPixel = 120 'config picture layout. picture.Fill.Solid() picture.Fill.Color.ObjectThemeColor = ThemeColor.Accent1 'delete picture. picture.Delete() ' save to an excel file workbook.Save("DeletePicture.xlsx")