OpenXML4J Project

Functional Cases

In the view to give a few examples of the use of OpenXML4J, this page show you several potential real world business cases categorized by business.

SOHO (Small Office and Home Office)

Nowadays, several businesses are using business oriented software such as a word proccessing software or spreadsheet to create their invoices or orders for their customers or suppliers.

In this case, Open XML and OpenXML4J will allow to process in a 'smart way' the data from these documents which were considered as “unstructured”. Important data (dates, amounts, ...) will now be flaged with tags to make automatic recognition and smart the extraction of relevant data. This will surely avoid the data redundancy and also to ensure the compatibility in the data transmission to the business partners information system (ERP, ...).

Banking Industry

First example: On its commercial bank website, the end user is able to check its current balance and with a simple click, download and open a worksheet - generated with OpenXML4J on the server - with all its account data ; then he can work with these data , for example to modify amortizing information in order to simulate a given loan or carry any other relevant operation. Naturally, this can be achieved by using any Open XML compatible software suite, be it MS Office, WordPerfect or even OpenOffice. The Open XML spreadsheet formulas can be generated with OpenXML4J as well as the whole document and under any environment (Unix/Linux-Oracle, Windows-SQL Server and so on).

Besides, the Open XML structure implies greatly reduced risks of file corruption and strengthens the security for internet based information exchanges.

Second example: A private bank’s branch office managing director wishes to address to its customers an eye catching report regarding their assets evolutions. Here again, OpenXML4J allows to export a professional looking report to PowerPoint (or OOo Presentation) or a wordprocessor (Word or OOo Writer for example).

Pharmaceutical Sector – Medical tests and Traceability

Example : Several reports are “half structured” with comments from doctors coming along with encrypted data containing tests results. OpenXML4J can then extract the relevant data using a business application specific XML schema proper to the pharmaceutical industry (For example CDISC (www.cdisc.org)). Later on, this XML data can be transmitted to healthcare authorities which will be able to automatically process data on their own information system using Java enable systems.

Healthcare Industry

Example : Information streams between doctors, patient’s medical records and insurance are done with specific schemas such as IHE/XDS (international healthcare standard). In this case, OpenXML4J allows interaction with such data formats, allowing doctors to easily generate - with a software using OpenXML4J (of course !) - and finalize a patient’s invoice with regular word processing software.

Resources and Energy Industry

An energy company enables its customers to check their electricity consumption in details. Here again, OpenXML4J plays a great role by allowing to automatically generate:

• Spreadsheets with formulas and customer data which could be merged with data from other sources so as to realize an ad-hoc analysis.
• Presentations and abstracts providing a quick and easy to use material for meetings between the customer and the energy company.

Knowledge Workers

OpenXML allows to create presentations from several slide decks referred on a web server. With the use of OpenXML4J, this interesting feature allows to quickly create presentations from different slide decks available on a web page (may be a Linux/Apache or Windows/IIS -> Java enable system).