How to get the count of converted pages in an Excel to PDF conversion
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.
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
