ExcelToPdfCPageStylePageNumbersText Property |
Set a custom page numbers in produced PDF document. Default value: "".
Namespace: SautinSoftAssembly: SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 2024.11.30
Syntax public string Text { get; set; }
Public Property Text As String
Get
Set
Property Value
StringRemarks
Default value: empty string
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
Example How to set page numbers in the output PDF document
using System;
using System.IO;
using SautinSoft;
namespace Sample
{
class Sample
{
static void Main(string[] args)
{
ExcelToPdf x = new ExcelToPdf();
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf;
x.PageStyle.PageNumFormat.Text = "Page {page} of {numPages}";
x.PageStyle.PageNumFormat.FontFace = "Arial";
x.PageStyle.PageNumFormat.FontSize = 14;
string excelFile = Path.GetFullPath(@"..\..\..\test.xlsx");
string pdfFile = Path.ChangeExtension(excelFile, ".pdf"); ;
try
{
x.ConvertFile(excelFile, pdfFile);
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(pdfFile) { UseShellExecute = true });
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.ReadLine();
}
}
}
}
How to set page numbers in the output PDF document
Imports System
Imports System.IO
Imports SautinSoft
Module Sample
Sub Main()
Dim x As New ExcelToPdf()
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf
x.PageStyle.PageNumFormat.Text = "Page {page} of {numPages}"
x.PageStyle.PageNumFormat.FontFace = "Arial"
x.PageStyle.PageNumFormat.FontSize = 14
Dim excelFile As String = Path.GetFullPath("..\..\..\test.xlsx")
Dim pdfFile As String = Path.ChangeExtension(excelFile, ".pdf")
Try
x.ConvertFile(excelFile, pdfFile)
System.Diagnostics.Process.Start(New System.Diagnostics.ProcessStartInfo(pdfFile) With {.UseShellExecute = True})
Catch ex As Exception
Console.WriteLine(ex.Message)
Console.ReadLine()
End Try
End Sub
End Module
See Also