ExcelWorksheetConversionOptions.PageSize Property

Namespace:

ceTe.DynamicPDF.Conversion

Assemblies:

DynamicPDF.Converter.dll

manages page size

public ExcelPageSize PageSize { get; set; }

Public Property PageSize As ExcelPageSize

Property Value

ExcelPageSize

Licensing Info

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

• An active DynamicPDF Subscription
• An active DynamicPDF Professional or Professional Plus Subscription with DynamicPDF Converter selected.
• A DynamicPDF Converter for .NET v3.X Developer license.

Examples

Imports ceTe.DynamicPDF.Conversion

Module Module1

Sub Main()

    ' Create new instance of Converter by providing suitable parameters.
     Dim excelConversion As ExcelConverter = New ExcelConverter("C:\MyDocument.xlsx")

     ' Events to know if conversion completed successfully or not
      AddHandler excelConversionDocumentParsing, AddressOf xlConverter_DocumentParsing

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

End Sub

    Sub xlConverter_DocumentParsing(ByVal sender As Object, ByVal e As ExcelDocumentParsingEventArgs)
         For Each excelWorksheet As ExcelWorksheet In e.Worksheets
             Dim excelWSOptions As ExcelWorksheetConversionOptions = excelWorksheet.ConversionOptions
             excelWSOptions.PageSize=ExcelPageSize.A4
             excelWorksheet.ConversionOptions.DefaultToFile = False
             excelWorksheet.ConversionOptions=excelWSOptions
         Next
    End Sub
End Module
 

using ceTe.DynamicPDF.Conversion;

class MyClass
{
    static void Main()
    {
        // Create new instance of Converter by providing suitable parameters.
        ExcelConverter excelConverter = new ExcelConverter(@"C:\MyDocument.xlsx");
       
        excelConverter.DocumentParsing += new ExcelDocumentParsing(xlConverter_DocumentParsing);
        
        //Call Convert method to start conversion
        excelConverter.Convert(@"C:\MyOutput.pdf");
    }
    static void xlConverter_DocumentParsing(object sender, ExcelDocumentParsingEventArgs e)
    {
        foreach (ExcelWorksheet excelWorksheet in e.Worksheets)
        {
            ExcelWorksheetConversionOptions excelWSOptions = excelWorksheet.ConversionOptions;
            excelWSOptions.PageSize=ExcelPageSize.A4;
            excelWorksheet.ConversionOptions.DefaultToFile = false;
            excelWorksheet.ConversionOptions=excelWSOptions;
        }
     }
}

See Also