Free Support Forum - aspose.com

Unable to find Aspose.Cells.Rendering.PdfOptions.OnePagePerSheet on version 6.x.x

Im using vb.net and aspose.cells 6.0.0. Im unable to find Aspose.Cells.Rendering.PdfOptions.


Any idea how to solve this? http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/render-one-pdf-page-per-excel-worksheet-excel-to-pdf-conversion.html

Hi,


Please use the following code for your need. It prints one Worksheet on one page of PDF by default. I have attached my input and output files for your reference. Regarding the documentation that you have mentioned in your post, we will look into it to update it soon.

VB.NET Code

Dim book = New Workbook(“C:\temp\pdf.xlsx”)

Dim op As New PdfSaveOptions()

op.SaveFormat = SaveFormat.Pdf

book.Save(“C:\temp<span class=“kwrd”>out.pdf”, op)

Hi,

Please change your code a bit. See the following example code for your reference on how to render PDF file with one page per worksheet.

Sample code:

var workbook = new Workbook(@“E:\test\Book1.xls”);

ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.OnePagePerSheet = true;
imgOptions.SaveFormat = SaveFormat.Pdf;

workbook.Save(“e:\test2\outonepagpersheet.pdf”);


And, we will update the documentation in accordance with the latest version v6.0.0 soon.

Thank you.

Thank you for this wonderful suite, Aspose.