Server 2009

Automate Printing with Excel

Example code is for an older version of Server, newer code is available.
// Copyright (c) 2019 ActivePDF, Inc.
// ActivePDF Server 2009
// Example generated 12/07/19 

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 © 2019 ActivePDF, Inc