This article explains about the different layout options available in Excel to PDF conversion in XlsIO using C#/VB.NET.
What is layout?
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
The following C#/VB.NET complete code snippet shows how to use layout options in Excel to PDF conversion in XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|