//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); //Set text font color. sheet.Range["A1:D4"].Value = "Font"; sheet.Range["A1:D4"].Font.Color = Color.Red; //Set cell color sheet.Range["A7:D10"].Value = "Green"; sheet.Range["A7:D10"].Interior.Color = Color.Green; //Set print black and white. sheet.PageSetup.BlackAndWhite = true; // Save to a pdf file workbook.Save("ConfigureBlackAndWhite.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) 'Set text font color. sheet.Range("A1:D4").Value = "Font" sheet.Range("A1:D4").Font.Color = Color.Red 'Set cell color sheet.Range("A7:D10").Value = "Green" sheet.Range("A7:D10").Interior.Color = Color.Green 'Set print black and white. sheet.PageSetup.BlackAndWhite = True ' save to a pdf file workbook.Save("ConfigureBlackAndWhite.pdf")