Automate Printing with Excel

• C#
• VB.NET
• VBS
• ASP
// Copyright (c) 2020 ActivePDF, Inc. // ActivePDF Server 2013 // Example generated 12/05/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; ServerDK.Results.ServerResult results; 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 results = oSVR.BeginPrintToPDF(); if (results.ServerStatus != ServerDK.Results.ServerStatus.Success) { ErrorHandler("BeginPrintToPDF", results, results.ServerStatus.ToString()); } // 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 results = oSVR.EndPrintToPDF(30); if (results.ServerStatus != ServerDK.Results.ServerStatus.Success) { ErrorHandler("EndPrintToPDF", results, results.ServerStatus.ToString()); } // Release Object oSVR = null; // Process Complete WriteResults("Done!"); } // Error Handling public static void ErrorHandler(string strMethod, ADK.Results.Result results, string errorStatus) { WriteResults("Error with " + strMethod); WriteResults(errorStatus); WriteResults(results.Details); if (results.Origin.Function != strMethod) { WriteResults(results.Origin.Class + "." + results.Origin.Function); } if (results.ResultException != null) { // To view the stack trace on an exception uncomment the line below //WriteResults(results.ResultException.StackTrace); } Environment.Exit(1); } // 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 2013
// Example generated 12/05/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;
    ServerDK.Results.ServerResult results;
    
    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
    results = oSVR.BeginPrintToPDF();
    if (results.ServerStatus != ServerDK.Results.ServerStatus.Success)
    {
      ErrorHandler("BeginPrintToPDF", results, results.ServerStatus.ToString());
    }
    
    // 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
    results = oSVR.EndPrintToPDF(30);
    if (results.ServerStatus != ServerDK.Results.ServerStatus.Success)
    {
      ErrorHandler("EndPrintToPDF", results, results.ServerStatus.ToString());
    }
    
    // Release Object
    oSVR = null;
    
    // Process Complete
    WriteResults("Done!");
  }
  
  // Error Handling
  public static void ErrorHandler(string strMethod, ADK.Results.Result results, string errorStatus)
  {
    WriteResults("Error with " + strMethod);
    WriteResults(errorStatus);
    WriteResults(results.Details);
    if (results.Origin.Function != strMethod)
    {
      WriteResults(results.Origin.Class + "." + results.Origin.Function);
    }
    if (results.ResultException != null)
    {
      // To view the stack trace on an exception uncomment the line below
      //WriteResults(results.ResultException.StackTrace);
    }
    Environment.Exit(1);
  }
  
  // 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);
    //}
  }
}