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. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

What are the different layout options in ExceltoPDF conversion?

Platform: WinForms |
Control: XlsIO |
Published Date: February 28, 2018 |
Last Revised Date: February 28, 2018

This article explains about the different layout options available in Excel to PDF conversion in XlsIO using C#/VB.NET.

What is layout?

In Excel to PDF conversion, layout defines scaling of the row and column of the worksheet. The following are the layout options in Excel to PDF conversion in XlsIO.

  • FitSheetOnOnePage
  • NoScaling
  • FitAllColumnsOnOnePage
  • FitAllRowsOnOnePage
  • CustomScaling
  • Automatic

By default, the layout option is Automatic.


When the FitSheetOnOnePage option is selected, the workbook will be converted into pdf with one page for each worksheet.



When NoScaling option is selected, the workbook will not use any scaling. Instead it will convert the worksheet based actual size of the column width and row height for entire workbook.



FitAllColumnsOnOnePage option is will make all the columns in a worksheet fit into single page.



All the rows in the worksheet will fit into single page when the FitAllRowsOnOnePage option is selected.



CustomScaling option uses the page setup zoom option while conversion like MS-Excel shows the page setup dialog box to set the zoom level when the custom scaling is selected.



Automatic option will convert the workbook based on which layout option will suit for every worksheet in a workbook. The default value is NoScaling.


Steps to use layout options in Excel to PDF conversion

  1. Initialize Excel to pdf converted setting and set the layout options.


  1. Instantiate Excel to PDF converter with workbook.


  1. Convert the workbook to PDF with the specified settings.


  1. Save the PDF file.


 To know more about Excel to PDF conversion in XlsIO, please refer the documentation.

Download Input file

Download Complete sample

The following C#/VB.NET complete code snippet shows how to use layout options in Excel to PDF conversion in XlsIO.





2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

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

Live Chat Icon For mobile