Output to PDF, specific Worksheet

[Joel Palmer]

Is there a way to output one specific worksheet to a PDF document?  Or, must I always rely on spreadsheet formatting?

[Tanya]

Hello Joel,

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[1];

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.

Regards,
Tanya
Telerik

 

 

[Joel Palmer]

Awesome.  I figured there had to be a way to do it.  I'll give it a try.

Thanks for your help,
Joel