Interface IPage

Base interface for Page class.

Namespace: Syncfusion.XlsIO.Interfaces
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public interface IPage

Properties

CenterFooter

Gets or sets center part of footer. Read/write string

Declaration
string CenterFooter { get; set; }
Property Value
Type
System.String
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of CenterFooter property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets center part of footer
        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");

        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");  
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");         
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

CenterFooterImage

Gets or sets image for center part of footer.

Declaration
Image CenterFooterImage { get; set; }
Property Value
Type
Image
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of CenterFooterImage property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets the image for center part of footer
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G";         

        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");  
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");         
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

CenterHeader

Gets or sets center part of header. Read/write string

Declaration
string CenterHeader { get; set; }
Property Value
Type
System.String
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of CenterHeader property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets center part of header
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg"); 

        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

CenterHeaderImage

Gets or sets image for center part of header.

Declaration
Image CenterHeaderImage { get; set; }
Property Value
Type
Image
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of CenterHeaderImage property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets the image for center part of header
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";    

        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

LeftFooter

Gets or sets left part of footer. Read/write string

Declaration
string LeftFooter { get; set; }
Property Value
Type
System.String
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of LeftFooter property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets left part of footer
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");

        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");         
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

LeftFooterImage

Gets or sets image for left part of footer.

Declaration
Image LeftFooterImage { get; set; }
Property Value
Type
Image
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of LeftFooterImage property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets the image for left part of footer
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 

        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");         
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

LeftHeader

Gets or sets left part of header. Read/write string

Declaration
string LeftHeader { get; set; }
Property Value
Type
System.String
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of LeftHeader property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets left part of header
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 

        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg"); 
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

LeftHeaderImage

Gets or sets image for left part of header.

Declaration
Image LeftHeaderImage { get; set; }
Property Value
Type
Image
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of LeftHeaderImage property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets the image for left part of header
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg");
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";  

        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg"); 
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

RightFooter

Gets or sets right part of footer. Read/write string

Declaration
string RightFooter { get; set; }
Property Value
Type
System.String
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of RightFooter property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets right part of footer
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");     

        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg"); 
        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");  
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");         
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

RightFooterImage

Gets or sets image for right part of footer.

Declaration
Image RightFooterImage { get; set; }
Property Value
Type
Image
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of RightFooterImage property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets the image for right part of footer
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";       

        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg"); 
        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");  
        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");         
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

RightHeader

Gets or sets right part of header. Read/write string

Declaration
string RightHeader { get; set; }
Property Value
Type
System.String
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of RightHeader property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets right part of header
        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");

        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");         
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

RightHeaderImage

Gets or sets image for right part of header.

Declaration
Image RightHeaderImage { get; set; }
Property Value
Type
Image
Remarks

&L Left aligns the characters that follow. &C Centers the characters that follow. &R Right aligns the characters that follow. &E Turns double-underline printing on or off. &X Turns superscript printing on or off. &Y Turns subscript printing on or off. &B Turns bold printing on or off. &I Turns italic printing on or off. &U Turns underline printing on or off. &S Turns strikethrough printing on or off. &D Prints the current date. &T Prints the current time. &F Prints the name of the document. &A Prints the name of the workbook tab. &P Prints the page number. &P+number Prints the page number plus the specified number. &P-number Prints the page number minus the specified number. && Prints a single ampersand. & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &N Prints the total number of pages in the document. To know more about page settings refer this link.

Examples

The following code illustrates the use of RightHeaderImage property.

      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1:T100"].Text = "PagePrint";
        sheet.PageSetup.DifferentFirstPageHF = true;

        //sets the image for right part of header
        sheet.PageSetup.FirstPage.RightHeaderImage = System.Drawing.Image.FromFile("sample6.jpg");
        sheet.PageSetup.FirstPage.RightHeader = "Right Header &G";

        sheet.PageSetup.FirstPage.CenterHeader = "Center Header &G";
        sheet.PageSetup.FirstPage.CenterHeaderImage = System.Drawing.Image.FromFile("sample2.jpg");         
        sheet.PageSetup.FirstPage.LeftHeader = "Left Header &G";
        sheet.PageSetup.FirstPage.LeftHeaderImage = System.Drawing.Image.FromFile("sample4.jpg"); 
        sheet.PageSetup.FirstPage.CenterFooter = "Center Footer &G"; 
        sheet.PageSetup.FirstPage.CenterFooterImage = System.Drawing.Image.FromFile("sample1.jpg");
        sheet.PageSetup.FirstPage.LeftFooter = "Left Footer &G"; 
        sheet.PageSetup.FirstPage.LeftFooterImage = System.Drawing.Image.FromFile("sample3.jpg");
        sheet.PageSetup.FirstPage.RightFooter = "Right Footer &G";
        sheet.PageSetup.FirstPage.RightFooterImage = System.Drawing.Image.FromFile("sample5.jpg");
        workbook.SaveAs("PageSetup.xlsx");
        workbook.Close();
      }

Extension Methods