Articles in this section
Category / Section

How to get the count of converted pages in an Excel to PDF conversion

2 mins read

PageCount property available under IBuiltInDocumentProperties shows the value only when the Excel document have the information of it. Otherwise, the default value will be returned.

The Excel document should first be converted to PDF to get the proper page count.

The following complete code snippet explains this.

C#

using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Excel2016;
    IWorkbook workbook = application.Workbooks.Open("../../Data/Template.xlsx");
    IWorksheet worksheet = workbook.Worksheets[0];
 
    ExcelToPdfConverter converter = new ExcelToPdfConverter(workbook);
    PdfDocument document = converter.Convert();
    document.Save("Output.pdf");
 
    PdfLoadedDocument loadedDocument = new PdfLoadedDocument("Output.pdf");
 
    //Get the page count
    int pageCount = loadedDocument.Pages.Count;
    loadedDocument.Close(true);
}

 

VB.NET

Using excelEngine As ExcelEngine = New ExcelEngine
    Dim application As IApplication = excelEngine.Excel
    application.DefaultVersion = ExcelVersion.Excel2016
    Dim workbook As IWorkbook = application.Workbooks.Open("../../Data/Template.xlsx")
    Dim worksheet As IWorksheet = workbook.Worksheets(0)
 
    Dim converter As ExcelToPdfConverter = New ExcelToPdfConverter(workbook)
    Dim document As PdfDocument = converter.Convert()
    document.Save("Output.pdf")
 
    Dim loadedDocument As PdfLoadedDocument = New PdfLoadedDocument("Output.pdf")
 
    'Get the page count
    Dim pageCount As Integer = loadedDocument.Pages.Count
    loadedDocument.Close(True)
End Using

 

A complete working sample can be downloaded from GetPageCount.Zip

Take a moment to peruse the documentation, where you can find basic worksheet data manipulation options along with features like Conditional Formatting, worksheet calculations through Formulas, adding Charts in worksheet or workbook, organizing and analyzing data through Tables and Pivot Tables, appending multiple records to worksheet using Template Markers, and most importantly PDF and Image conversions with code examples.

Refer here to explore the rich set of Syncfusion Essential XlsIO features.

Note:

Starting with v16.2.0.x, if you reference Syncfusion assemblies from trial setup or from the NuGet feed, include a license key in your projects. Refer to link to learn about generating and registering Syncfusion license key in your application to use the components without trail message

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied