This object is a specialized version of the PrintJob object. In addition
to all the features from the PrintJob object, the
ExcelPrintJobEx object includes numerous Excel specific
If you need to set Excel specific options, use either ExcelPrintJobEx or ExcelPrintJob instead of the generalized PrintJob object. However, do not use this object for printing documents other than the ones Excel can handle. Some supported file types for ExcelPrintJobEx include XLS and XLSX.
While ExcelPrintJobEx and ExcelPrintJob share some common properties, there are considerable differences between the two as well. Be sure to refer to the documentation to see which Excel specific options each respective object supports. Of particular note is that ExcelPrintJobEx supports two considerably different modes of operation; see the NativeOfficePDF property for more information on this.
Be aware that ExcelPrintJobEx only works with Excel 2007 or Excel 2010. Note that Excel 2007 requires the free "Save as PDF or XPS" add-in for Office 2007 to be installed. This add-in is available from Microsoft and does not install with easyPDF SDK. Excel 2010 does not require any add-ins.
Furthermore, if NativeOfficePDF is False (its default value), then .NET 3.0 or higher plus XmlLite (XmlLite should install as part of Office 2007) are required to use ExcelPrintJobEx. If NativeOfficePDF is True, then this requirement does not apply.
Set oPrinter = CreateObject("easyPDF.Printer.7") Set oPrintJob = oPrinter.ExcelPrintJobEx ' Set Excel specific option oPrintJob.PrintAllSheets = True oPrintJob.PrintOut "C:\input.xls", "C:\output.pdf"
Dim oPrinter As Printer = CreateObject("easyPDF.Printer.7") Dim oPrintJob As ExcelPrintJobEx = oPrinter.ExcelPrintJobEx ' Set Excel specific option oPrintJob.PrintAllSheets = True oPrintJob.PrintOut "C:\input.xls", "C:\output.pdf"
Printer oPrinter = new Printer(); ExcelPrintJobEx oPrintJob = oPrinter.ExcelPrintJobEx; // Set Excel specific option oPrintJob.PrintAllSheets = true; oPrintJob.PrintOut(@"C:\input.xls", @"C:\output.pdf");