Allows to set custom page numbers in produced document.

Namespace:  SautinSoft
Assembly:  SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 4.2.7.24

Syntax

      
 C#  Visual Basic 
public string PageNumFormat { get; set; }
Public Property PageNumFormat As String

Remarks

Using this property you may set custom page numbers as you wish.



These are special keywords to custom page numbers:

{page} - current page number
{numpages} - total pages
{fontface=N} - Font face for whole page numbers string. Where N is font name.

For example:
x.PageStyle.PageNumFormat="Page {page}{fontface=Times New Roman}";

{fontsize=N} - Font size for whole page numbers string. Where N is font size.

For example:
x.PageStyle.PageNumFormat="Page {page}{fontsize=7.5} of {numpages}";

{posxmm=N} - Position of page numbers by horizontal from left corner of page. Where N - is value in mm.
{posxinch=N} - Position of page numbers by horizontal from left corner of page. Where N - is value in inches.
{posymm=N} - Position of page numbers by vertical from bottom corner of page. Where N - is value in mm.
{posyinch=N} - Position of page numbers by vertical from bottom corner of page. Where N - is value in inches.

By default: Page numbers located at the bottom-right of page and font face is "Helvetica" and font size is "10".

These are samples of using this property:

x.PageStyle.PageNumFormat="Page {page} of {numpages}";



x.PageStyle.PageNumFormat="This is page number {page}";



x.PageStyle.PageNumFormat="{FontName=Algerian}{fontSize=14}{posXmm=100}{posYinch=0.5}Page {page} of {numPages}";



x.PageStyle.PageNumFormat="Seite {page} von {numpages}";



x.PageStyle.PageNumFormat="{FontName=Mistral}{fontSize=22.5}{posXmm=30}{posYinch=0.5}PAGE {page} OF {numPages}";



Examples

CopyAdd page numbers in the resulting PDF using C#
using System;
using System.IO;
using SautinSoft;

namespace Sample
{
    class Sample
    {
        static void Main(string[] args)
        {
            // Add page numbers in the resulting PDF.
            ExcelToPdf x = new ExcelToPdf();

            // Set PDF as output format.
            x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf;

            // Set page numbers in format "Page 1 of N" formatted by Arial, 14 pt.
            x.PageStyle.PageNumFormat = "{FontName=Arial}{fontSize=14}Page {page} of {numPages}";

            string excelFile = Path.GetFullPath(@"..\..\..\..\test.xls");
            string pdfFile = Path.ChangeExtension(excelFile, ".pdf"); ;

            try
            {
                x.ConvertFile(excelFile, pdfFile);
                System.Diagnostics.Process.Start(pdfFile);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                Console.ReadLine();
            }

        }
    }
}
CopyAdd page numbers in the resulting PDF using VB.Net
Imports System
Imports System.IO
Imports SautinSoft

Module Sample

    Sub Main()
        ' Add page numbers in the resulting PDF.
        Dim x As New ExcelToPdf()

        ' Set PDF as output format.
        x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf

        ' Set page numbers in format "Page 1 of N" formatted by Arial, 14 pt.
        x.PageStyle.PageNumFormat = "{FontName=Arial}{fontSize=14}Page {page} of {numPages}"

        Dim excelFile As String = Path.GetFullPath("..\..\..\test.xls")
        Dim pdfFile As String = Path.ChangeExtension(excelFile, ".pdf")


        Try
            x.ConvertFile(excelFile, pdfFile)
            System.Diagnostics.Process.Start(pdfFile)
        Catch ex As Exception
            Console.WriteLine(ex.Message)
            Console.ReadLine()
        End Try

    End Sub
End Module

See Also