ExcelWorksheetConversionOptions Constructors

Initializes a new instance of the ExcelWorksheetConversionOptions class

public ExcelWorksheetConversionOptions(bool defaultToFile)

Public Sub New (defaultToFile As Boolean)

Parameters

Licensing Info

This constructor 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

Example shows how to ExcelWorksheetConversionOptions constructor with defaultToFile as parameter.

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 = New ExcelWoorksheetConversionOptions(True)
             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 = new ExcelWorksheetConversionOptions(true);
            excelWorksheet.ConversionOptions=excelWSOptions;
        }
     }
}

Initializes a new instance of the ExcelWorksheetConversionOptions class

public ExcelWorksheetConversionOptions(ExcelPageSize pageSize, double margins)

Public Sub New (pageSize As ExcelPageSize, margins As Double)

Parameters

Licensing Info

This constructor 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

Example shows how to ExcelWorksheetConversionOptions constructor with ExcelPageSize and margin as parameter.

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 = New ExcelWoorksheetConversionOptions(ExcelPageSize.A4,50)
             excelWSOptions.DefaultToFile=True
             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 = new ExcelWorksheetConversionOptions(ExcelPageSize.A4,50);
            excelWSOptions.DefaultToFile=true;
            excelWorksheet.ConversionOptions=excelWSOptions;
        }
     }
}

Initializes a new instance of the ExcelWorksheetConversionOptions class.

public ExcelWorksheetConversionOptions(ExcelPageSize pageSize, double leftAndRightMargin, double topAndBottomMargin)

Public Sub New (pageSize As ExcelPageSize, leftAndRightMargin As Double, topAndBottomMargin As Double)

Parameters

Licensing Info

This constructor 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

Example shows how to ExcelWorksheetConversionOptions constructor with ExcelPageSize, leftAndRightmargin and topAndBottommargin as parameter.

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 = New ExcelWoorksheetConversionOptions(ExcelPageSize.A4,50,100)
             excelWSOptions.DefaultToFile=True
             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 = new ExcelWorksheetConversionOptions(ExcelPageSize.A4,50,100);
            excelWSOptions.DefaultToFile=true;
            excelWorksheet.ConversionOptions=excelWSOptions;
        }
     }
}

Initializes a new instance of the ExcelWorksheetConversionOptions class.

public ExcelWorksheetConversionOptions(ExcelPageSize pageSize, PageOrientation? orientation, double margin)

Public Sub New (pageSize As ExcelPageSize, orientation As PageOrientation?, margin As Double)

Parameters

Licensing Info

This constructor 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

Example shows how to ExcelWorksheetConversionOptions constructor with ExcelPageSize, pageOrientation and margin as parameter.

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 = New ExcelWoorksheetConversionOptions(ExcelPageSize.A4,PageOrientation.Portrait,50)
             excelWSOptions.DefaultToFile=True
             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 = new ExcelWorksheetConversionOptions(ExcelPageSize.A4,PageOrientation.Portrait,50);
            excelWSOptions.DefaultToFile=true;
            excelWorksheet.ConversionOptions=excelWSOptions;
        }
     }
}

Initializes a new instance of the ExcelWorksheetConversionOptions class.

public ExcelWorksheetConversionOptions(ExcelPageSize pageSize, PageOrientation? orientation, double leftAndRightMargin, double topAndBottomMargin)

Public Sub New (pageSize As ExcelPageSize, orientation As PageOrientation?, leftAndRightMargin As Double, topAndBottomMargin As Double)

Parameters

Licensing Info

This constructor 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

Example shows how to ExcelWorksheetConversionOptions constructor with ExcelPageSize, PageOrientation, LeftAndRightMargin and TopAndBottomMargin as parameter.

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 = New ExcelWoorksheetConversionOptions(ExcelPageSize.A4,PageOrientation.Portrait,100,50)
             excelWSOptions.DefaultToFile=True
             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 = new ExcelWorksheetConversionOptions(ExcelPageSize.A4,PageOrientation.Portrait,100,50);
            excelWSOptions.DefaultToFile=true;
            excelWorksheet.ConversionOptions=excelWSOptions;
        }
     }
}

Initializes a new instance of the ExcelWorksheetConversionOptions class

public ExcelWorksheetConversionOptions(ExcelWorksheetConversionOptions xlWorkSheetOptions)

Public Sub New (xlWorkSheetOptions As ExcelWorksheetConversionOptions)

Parameters

Licensing Info

This constructor 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.