How to create a PDF file for every page in Excel ?

A PDF file can be created for every page in a worksheet using XlsIO. This can be achieved by identifying page breaks in a worksheet and copying the range within page breaks to a temporary worksheet. This temporary worksheet is given as input for ExcelToPdfConverter which generates a PDF file. The sample code for creating a PDF file for every page in an Excel worksheet is given below

C#

VB

The sample illustrating this behavior can be downloaded from here.