//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet sheet = workbook.Worksheets[0]; //Set text. sheet.Range["A1:G10"].Value = "Text"; //Add picture in sheet. System.IO.Stream stream = this.GetResourceStream("logo.png"); GrapeCity.Documents.Excel.Drawing.IShape picture = sheet.Shapes.AddPicture(stream, GrapeCity.Documents.Excel.Drawing.ImageType.PNG, 20, 20, 395, 60); //Add header graphic. System.IO.Stream stream1 = this.GetResourceStream("logo.png"); sheet.PageSetup.CenterHeader = "&G"; sheet.PageSetup.CenterHeaderPicture.SetGraphicStream(stream1, Drawing.ImageType.PNG); sheet.PageSetup.CenterHeaderPicture.Width = 100; sheet.PageSetup.CenterHeaderPicture.Height = 13; //Set print without graphics in page content area. sheet.PageSetup.Draft = true; // Save to a pdf file workbook.Save("ConfigureDraft.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim sheet As IWorksheet = workbook.Worksheets(0) 'Set text. sheet.Range("A1:G10").Value = "Text" 'Add picture in sheet. Dim stream As IO.Stream = GetResourceStream("logo.png") Dim picture As IShape = sheet.Shapes.AddPicture(stream, ImageType.PNG, 20, 20, 395, 60) 'Add header graphic. Dim stream1 As IO.Stream = GetResourceStream("logo.png") sheet.PageSetup.CenterHeader = "&G" sheet.PageSetup.CenterHeaderPicture.SetGraphicStream(stream1, ImageType.PNG) sheet.PageSetup.CenterHeaderPicture.Width = 100 sheet.PageSetup.CenterHeaderPicture.Height = 13 'Set print without graphics in page content area. sheet.PageSetup.Draft = True ' save to a pdf file workbook.Save("ConfigureDraft.pdf")