//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet sheet = workbook.Worksheets[0]; 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); sheet.Range["B2:D4"].Value = "Text"; sheet.PageSetup.PrintGridlines = true; //Set scaling. sheet.PageSetup.Zoom = 200; // Save to a pdf file workbook.Save("ConfigureScaling.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim sheet As IWorksheet = workbook.Worksheets(0) Dim stream As IO.Stream = GetResourceStream("logo.png") Dim picture As IShape = sheet.Shapes.AddPicture(stream, ImageType.PNG, 20, 20, 395, 60) sheet.Range("B2:D4").Value = "Text" sheet.PageSetup.PrintGridlines = True 'Set scaling. sheet.PageSetup.Zoom = 200 ' save to a pdf file workbook.Save("ConfigureScaling.pdf")