ExcelDocumentParsingEventArgs.Worksheets Property

A collection of all the sheets in the specified or active workbook.

public List<ExcelWorksheet> Worksheets { get; set; }
Public Property Worksheets As List(Of ExcelWorksheet)

Property Value

List<ExcelWorksheet>

Licensing Info

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

Examples

Example shows how to apply conversion options to specific worksheet.
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
             Dim xlPageScaling As ExcelPageScaling = excelWSOptions.PageScaling
             Dim zoomxlPageScaling As ZoomExcelPageScaling = xlPageScaling.ZoomExcelPageScaling
             zoomxlPageScaling.ZoomPercentage = 50
             excelWorksheet.ConversionOptions.DefaultToFile = False
         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;
            ExcelPageScaling xlPageScaling = excelWSOptions.PageScaling;
            ZoomExcelPageScaling zoomxlPageScaling = xlPageScaling.ZoomExcelPageScaling;
            zoomxlPageScaling.ZoomPercentage = 50;
            excelWorksheet.ConversionOptions.DefaultToFile = false;
        }
     }
}

See Also

ExcelDocumentParsingEventArgs
ceTe.DynamicPDF.Conversion

In this topic