AOP Logo

Last update: October 2021

About APEX Office Print

Goal

APEX Office Print makes printing and exporting (docx, xlsx, pptx, pdf, html, md, txt, csv, ics and more) in Oracle Application Express (APEX) or just in PL/SQL a lot easier.

Make a template in Office, HTML or Markdown, choose data from your database and merge them into one. You can easily print PDFs, Office documents, HTML or Markdown in no time. It saves you time and effort by creating templates in which you can easily integrate your data.

APEX Office Print (AOP) is a product of APEX R&D, located in Leuven, Belgium.

We are an experienced partner that helps you facilitate, improve, and accelerate your business through new and innovative solutions. Built on in-depth technical expertise, our company provides custom-made IT services for managing business data and processes.

AOP Main Features

APEX Office Print focuses on following:

  1. Simple Printing It is fast, easy and saves you money. It's the only solution on the market that is fully integrated with APEX. For example, you can print or export your Interactive Reports and Grids data in a second.

  2. Quick and Easy Setup Simply Import the APEX Plug-in in your application.

  3. Any Data Type Support Text, images, barcodes, formulas… it is easy to merge your data with any template you create.

  4. Scalable and Secure APEX Office Print is a scalable and secure product that fits your every printing requirement.

  5. PL/SQL API support It gives you the ability to run and retrieve reports from the AOP server directly from your PL/SQL code.

  6. Optimized for Performance Great design with finest details to enhance your business productivity.

  7. Flexible APEX Office Print is a print server allowing you to create templates in Word, Excel, and PowerPoint for any type of data.

Architecture

AOP Architecture

It's the database (APEX Plug-in, PL/SQL API, REST Webservice) that is doing a request to the AOP Server (either on-premises or on our cloud). The template together with the data is sent in JSON format to the AOP Server. The browser doesn't need to have access to the AOP server.

How it works (overview)

How it works How it works

How it works (technical)

The APEX Office Print package consists of a server component, an Oracle APEX plug-in, and the PL/SQL API.

The server part returns generated documents upon receiving HTTP POST requests. These requests require a structured JSON file that for example can be inferred from a SQL database. The server will generate the relevant output files merging the data with the given templates.

The Oracle Application Express (APEX) plug-in will generate the HTTP POST requests for the server. The plug-in makes it easy to select a template, your data source, and the output format straight from within your APEX application.

The PL/SQL API allows to print directly from the Oracle database. The PL/SQL API fits perfectly if you need to setup automatic printing through a job or do a mail merge.

A sample application comes with the download, so you see plenty of use cases in action.

Cloud vs On-Premises

There are two types of versions available:

  • a cloud version, which will send the requests to APEX Office Print in the cloud.
  • an on-premises version, which includes the server component of APEX Office Print. It's an executable you run on your own server and in the APEX Plug-in you reference your own local version of APEX Office Print. In this case nothing is sent to the AOP cloud.

License

This is commercial software; you need to obtain a valid license in order to use this software and plug-in in your application. For the on-premises version a license is required per server (MID i.e. machine id) on which you are running APEX Office Print.

Please visit our website https://www.apexofficeprint.com/ for the different packages.

You can even sign up for a FREE Cloud account.

Copyright © 2015-2021, APEX R&D - United Codes

All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure that are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or de-compilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.