Interface IPage
Base interface for Page class.
Namespace: Syncfusion.XlsIO.Interfaces
Assembly: Syncfusion.XlsIO.NET.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 |
|---|
| 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.
<pre><code class="lang-csharp">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.
<pre><code class="lang-csharp">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 |
|---|
| 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.
<pre><code class="lang-csharp">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.
<pre><code class="lang-csharp">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 |
|---|
| 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.
<pre><code class="lang-csharp">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.
<pre><code class="lang-csharp">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 |
|---|
| 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.
<pre><code class="lang-csharp">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.
<pre><code class="lang-csharp">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 |
|---|
| 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.
<pre><code class="lang-csharp">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.
<pre><code class="lang-csharp">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 |
|---|
| 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.
<pre><code class="lang-csharp">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.
<pre><code class="lang-csharp">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();
}