//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet sheet = workbook.Worksheets[0]; //Set data. sheet.Range["A1:G10"].Value = "Text"; //Set page header. sheet.PageSetup.LeftHeader = "&\"Arial,Italic\"LeftHeader"; sheet.PageSetup.RightHeader = "&KFF0000GrapeCity"; sheet.PageSetup.CenterHeader = "&P"; //Set page footer picture. System.IO.Stream stream = this.GetResourceStream("logo.png"); sheet.PageSetup.CenterFooter = "&G"; sheet.PageSetup.CenterFooterPicture.SetGraphicStream(stream, Drawing.ImageType.PNG); sheet.PageSetup.CenterFooterPicture.Width = 100; sheet.PageSetup.CenterFooterPicture.Height = 13; // Save to a pdf file workbook.Save("ConfigureHeaderFooter.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim sheet As IWorksheet = workbook.Worksheets(0) 'Set data. sheet.Range("A1:G10").Value = "Text" 'Set page header. sheet.PageSetup.LeftHeader = "&""Arial,Italic""LeftHeader" sheet.PageSetup.RightHeader = "&KFF0000GrapeCity" sheet.PageSetup.CenterHeader = "&P" 'Set page footer picture. Dim stream As IO.Stream = GetResourceStream("logo.png") sheet.PageSetup.CenterFooter = "&G" sheet.PageSetup.CenterFooterPicture.SetGraphicStream(stream, ImageType.PNG) sheet.PageSetup.CenterFooterPicture.Width = 100 sheet.PageSetup.CenterFooterPicture.Height = 13 ' save to a pdf file workbook.Save("ConfigureHeaderFooter.pdf")