We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

ExcelToPdfConverter doesn''t fit to one page

Thread ID:

Created:

Updated:

Platform:

Replies:

100890 Sep 12,2011 10:53 PM UTC Sep 15,2011 06:29 AM UTC ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On September 12, 2011 10:53 PM UTC

The attached Excel document is set to "Fit Sheet on One Page" and prints that way from Excel. When I convert it to a pdf using the ExcelToPdfConverter code below, the pdf has columns A-G on one page and H-K on another. Is there any way to get ExcelToPdfConverter to print it the same way Excel does? Also, is there any documentation available for ExcelToPdfConverter?



SampleDoc_54aca948.zip

Sridhar [Syncfusion]
Replied On September 13, 2011 08:48 AM UTC

HI Jim,

Thank you very much for using Syncfusion products.

To set the excel document to fit into one sheet we need to set the ExcelToPDFConverterSettings LayoutOptions property to settings.LayoutOptions = LayoutOptions.FitSheetOnOnePage.

We have prepared the sample at our side for the same and attached here for your reference. Please try the attached sample at your side and let us know if these helps you.

Please let us know if you require any further clarifications.

Regards,
Sridhar.S



CS-ExcelTOPDF_8b9280c6.zip

Administrator [Syncfusion]
Replied On September 14, 2011 07:34 PM UTC

Thank you, that worked perfectly!


Sridhar [Syncfusion]
Replied On September 15, 2011 06:29 AM UTC

Hi Jim,

Thanks for the notification.

Please let me know if you require any further assistance on this and we are happy to help you out.

Thanks,
Sridhar.S


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;