Automate Printing with Excel

• C#
• VB.NET
• VBS
• ASP
// Copyright (c) 2020 ActivePDF, Inc. // ActivePDF Server 2009 // Example generated 01/20/20 using System; // Make sure to add the ActivePDF product .NET DLL(s) to your application. // .NET DLL(s) are typically found in the products 'bin' folder. class Examples { public static void Example() { string strPath; int intStartPrinting; int intWait; strPath = System.AppDomain.CurrentDomain.BaseDirectory; // Instantiate Object APServer.Server oSVR = new APServer.Server(); // Path and filename of output oSVR.OutputDirectory = strPath; oSVR.NewDocumentName = "Output.pdf"; // Start the print job intStartPrinting = oSVR.StartPrinting(); if (intStartPrinting != 0) { ErrorHandler("StartPrinting", intStartPrinting); } // Automate Excel to print a document to activePDF Server // NOTE: You must add the 'Microsoft Excel <<version number>> Object Library' // COM object as a reference to your .NET application to access the Excel Object. Microsoft.Office.Interop.Excel._Application oXLS = new Microsoft.Office.Interop.Excel.Application(); oXLS.DisplayAlerts = false; oXLS.Visible = false; object m = System.Type.Missing; Microsoft.Office.Interop.Excel._Workbook oWB = oXLS.Workbooks.Open(strPath + "excel.xls", m, true, m, m, m, true, m, m, false, false, m, false); oWB.Activate(); oWB.PrintOut(1, 999, 1, false, oSVR.NewPrinterName, false, false); oWB.Close(0); oXLS.Quit(); oWB = null; oXLS = null; // Wait(seconds) for job to complete intWait = oSVR.Wait(30); if (intWait != 0) { ErrorHandler("Wait", intWait); } // Release Object oSVR = null; // Process Complete WriteResults("Done!"); } // Error Handling public static void ErrorHandler(string strMethod, object rtnCode) { WriteResults(strMethod + " error: " + rtnCode.ToString()); } // Write output data public static void WriteResults(string content) { // Choose where to write out results // Debug output //System.Diagnostics.Debug.WriteLine("ActivePDF: * " + content); // Console Console.WriteLine(content); // Log file //using (System.IO.TextWriter writer = new System.IO.StreamWriter(System.AppDomain.CurrentDomain.BaseDirectory + "application.log", true)) //{ // writer.WriteLine("[" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "]: => " + content); //} } }

// Copyright (c) 2020 ActivePDF, Inc.
// ActivePDF Server 2009
// Example generated 01/20/20 

using System;

// Make sure to add the ActivePDF product .NET DLL(s) to your application.
// .NET DLL(s) are typically found in the products 'bin' folder.

class Examples
{
  public static void Example()
  {
    string strPath;
    int intStartPrinting;
    int intWait;
    
    strPath = System.AppDomain.CurrentDomain.BaseDirectory;

    // Instantiate Object
    APServer.Server oSVR = new APServer.Server();
    
    // Path and filename of output
    oSVR.OutputDirectory = strPath;
    oSVR.NewDocumentName = "Output.pdf";
    
    // Start the print job
    intStartPrinting = oSVR.StartPrinting();
    if (intStartPrinting != 0)
    {
      ErrorHandler("StartPrinting", intStartPrinting);
    }
    
    // Automate Excel to print a document to activePDF Server
    // NOTE: You must add the 'Microsoft Excel <<version number>> Object Library'
    // COM object as a reference to your .NET application to access the Excel Object.
    Microsoft.Office.Interop.Excel._Application oXLS = new Microsoft.Office.Interop.Excel.Application();
    oXLS.DisplayAlerts = false;
    oXLS.Visible = false;
    object m = System.Type.Missing;
    Microsoft.Office.Interop.Excel._Workbook oWB = oXLS.Workbooks.Open(strPath + "excel.xls", m, true, m, m, m, true, m, m, false, false, m, false);
    oWB.Activate();
    oWB.PrintOut(1, 999, 1, false, oSVR.NewPrinterName, false, false);
    oWB.Close(0);
    oXLS.Quit();
    oWB = null;
    oXLS = null;
    
    // Wait(seconds) for job to complete
    intWait = oSVR.Wait(30);
    if (intWait != 0)
    {
      ErrorHandler("Wait", intWait);
    }
    
    // Release Object
    oSVR = null;
    
    // Process Complete
    WriteResults("Done!");
  }
  
  // Error Handling
  public static void ErrorHandler(string strMethod, object rtnCode)
  {
    WriteResults(strMethod + " error:  " + rtnCode.ToString());
  }
  
  // Write output data
  public static void WriteResults(string content)
  {
    // Choose where to write out results
  
    // Debug output
    //System.Diagnostics.Debug.WriteLine("ActivePDF: * " + content);
  
    // Console
    Console.WriteLine(content);
  
    // Log file
    //using (System.IO.TextWriter writer = new System.IO.StreamWriter(System.AppDomain.CurrentDomain.BaseDirectory + "application.log", true))
    //{
    //    writer.WriteLine("[" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "]: => " + content);
    //}
  }
}