FitExcelPageScaling

Represents all the properties and methods that are needed to change the excel page size to fit the page

public class FitExcelPageScaling
Public Class FitExcelPageScaling

Inheritance: ObjectFitExcelPageScaling

Licensing Info

This class is a DynamicPDF Converter feature. One of the following is required for non-evaluation usage:

Examples

Example shows how to use FitExcelPageScaling class.
Imports ceTe.DynamicPDF.Conversion

Module Module1

Sub Main()

     ' Create new instance of conversionOptions.
     Dim conversionOptions As ExcelConversionOptions =  New ExcelConversionOptions(ExcelPageSize.A4,10,10)
     Dim fitExcelPageScaling As fitExcelPageScaling = New FitExcelPageScaling(1,1)
     Dim excelPageScaling As ExcelPageScaling = New ExcelPageScaling()
     excelPageScaling.FitExcelPageScaling = fitExcelPageScaling
     conversionOptions.PageScaling = excelPageScaling
    ' Create new instance of Converter by providing suitable parameters.
     Dim excelConversion As ExcelConverter = New ExcelConverter("C:\MyDocument.xlsx",conversionOptions)

     ' Call Convert method to start conversion
     excelConversion.Convert("C:\MyOutput.pdf")

End Sub

End Module
 
using ceTe.DynamicPDF.Conversion;

class MyClass
{
    static void Main()
    {
        //Create new instance of conversionOptions.
        ExcelConversionOptions conversionOptions = new ExcelConversionOptions(ExcelPageSize.A4,10,10);
        FitExcelPageScaling fitExcelPageScaling = new FitExcelPageScaling(1,1);
        ExcelPageScaling excelPageScaling = new ExcelPageScaling();
        excelPageScaling.FitExcelPageScaling = fitExcelPageScaling;
        conversionOptions.PageScaling = excelPageScaling;
        
        // Create new instance of Converter by providing suitable parameters.
        ExcelConverter excelConverter = new ExcelConverter(@"C:\MyDocument.xlsx",conversionOptions);
       
        //Call Convert method to start conversion
        excelConverter.Convert(@"C:\MyOutput.pdf");
    }   
}

Constructors

FitExcelPageScaling()Initializes a new instance of the FitExcelPageScaling class.
FitExcelPageScaling(FitExcelPageScaling)Initializes a new instance of the FitExcelPageScaling class.
FitExcelPageScaling(Int32, Int32)Initializes a new instance of the FitExcelPageScaling class.

Properties

PagesByTallReturns or sets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets.
PagesByWideReturns or sets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets.

Methods

Equals(Object)Determines whether the specified Object is equal to the current Object .
(Inherited from Object)
GetHashCode()Serves as a hash function for a particular type.
(Inherited from Object)
GetType()Gets the Type of the current instance.
(Inherited from Object)
ToString()Returns a String that represents the current Object .
(Inherited from Object)

See Also

ceTe.DynamicPDF.Conversion

In this topic