By default, the PdfFormatProvider exports the active worksheet only. If your goal is to export a specific worksheet you could set the Workbook's ActiveWorksheet property to point to it:
workbook.ActiveWorksheet = workbook.Worksheets;
If you would like to control what is exported in what page in the pdf, you can use the PdfExportSettings class, as is shown in the sample code in Example 2 in the Pdf Settings article
. Each of the ranges specified in the code will be printed on a separate page.
Hope this helps.
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.