//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); var fileStream = this.GetResourceStream("xlsx\\PageSetup Demo.xlsx"); workbook.Open(fileStream); IWorksheet worksheet = workbook.Worksheets[0]; //Set first page headerfooter worksheet.PageSetup.DifferentFirstPageHeaderFooter = true; worksheet.PageSetup.FirstPage.CenterHeader.Text = "&T"; worksheet.PageSetup.FirstPage.RightFooter.Text = "&D"; //Set first page headerfooter's graphic worksheet.PageSetup.FirstPage.LeftFooter.Text = "&G"; System.IO.Stream stream = this.GetResourceStream("logo.png"); worksheet.PageSetup.FirstPage.LeftFooter.Picture.SetGraphicStream(stream, ImageType.PNG); worksheet.PageSetup.FirstPage.LeftFooter.Picture.Width = 100; worksheet.PageSetup.FirstPage.LeftFooter.Picture.Height = 13; // Save to an excel file workbook.Save("ConfigFirstPageHeaderFooter.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim fileStream = GetResourceStream("PageSetup Demo.xlsx") workbook.Open(fileStream) Dim worksheet As IWorksheet = workbook.Worksheets(0) 'Set first page headerfooter worksheet.PageSetup.DifferentFirstPageHeaderFooter = True worksheet.PageSetup.FirstPage.CenterHeader.Text = "&T" worksheet.PageSetup.FirstPage.RightFooter.Text = "&D" 'Set first page headerfooter's graphic worksheet.PageSetup.FirstPage.LeftFooter.Text = "&G" Dim stream As IO.Stream = GetResourceStream("logo.png") worksheet.PageSetup.FirstPage.LeftFooter.Picture.SetGraphicStream(stream, ImageType.PNG) worksheet.PageSetup.FirstPage.LeftFooter.Picture.Width = 100 worksheet.PageSetup.FirstPage.LeftFooter.Picture.Height = 13 ' save to an excel file workbook.Save("ConfigFirstPageHeaderFooter.xlsx")