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.
Unfortunately, activation email could not send to your email. Please try again.

ExcelToPdfConverter doesn''t fit to one page

Thread ID:





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

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?


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

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.



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

Thank you, that worked perfectly!

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

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.



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.

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.