PL/OFFX - The MS Office file generator

Create and process MS Office files in your Oracle database


PL/OFFX provides a tool for reporting and authoring your documents and worksheets faster, easier and more secure than other tools. If you use an Oracle server you can use the resources provided to you by the Oracle server more efficiently because of the PL/SQL language. Use your desktop application or SQL*PLUS to create the documents and sheets you need in high quality.


Some benefits of the PL/SQL language:

  • Minimal security risks because of the integration into your Oracle server
  • It is a widely known language between programmers because of its simplicity and efficiency.
  • There is no need for a separate tool, therefore you can achieve higher performance at a lower cost.
  • You can easily access and use data from your Oracle server through PL/SQL.

PL/OFFX is the perfect solution for companies using XLSX sheets and DOCX documents. It provides every tool to format and design your documents and sheets.


Using the Template Engine

Quick and Easy

1.Template

Create a template in Microsoft Word

More info

2.Data Model

Create your data sources in PL/SQL

More info

3.Build

Merge them with the PL/PDF Reporter

More info

4.Run

Execute the merged code as a simple PL/SQL program

Given the integration of the PL/SQL language it is one of the quickest and easiest ways to generate the reports or documents you need based on data from your Oracle server. Since PL/OFFX deals with the burdens of the XML data structures you can focus on arranging the data and text or even graphics, images, formulas and filters.


You can use the PL/OFFX for the following tasks:


  • Create or Parse DOCX documents directly on an Oracle server
  • Create or Parse XLSX sheets on an Oracle server
  • Import XLS/XLSX sheets data directly into your database
  • Create reports and documents from database
  • Add reporting capability to APEX applications


Core benefits


Template engine

With our MS Word based template engine you can design your PDF files easily and make your Oracle database PDFs mesmerizing

Everything is PL/SQL

All parts of PL/OFFX are implemented in native Oracle PL/SQL language, you don't need to know any other programming language such as Java or JavaScript

Fast Development

You don't have to worry about template creation anymore, because users can easily create the report layouts using Microsoft Word only

Separated Placeholders

PL/OFFX uses MS Word Content Control items, in which the user can switch visibility on/off. When the control items are switched off the layout of the report contains the visible items only

Separated Data and Layout

Your layout and data model are created separately, you don't have to create layouts for every data model, therefore the report generation is much faster

Cloud ready

PL/OFFX is designed from ground up for the cloud. PL/PDF Reporter applications scale up with your Oracle Database when you have high demand. They run in Oracle RAC implementations with zero effort


Do you have questions? Contact us!

More Information
Write your message