Excel generation example – Custom Java functionality on Oracle PaaS/JCS cloud by Jang-Vijay Singh

image

Introduction

In this example, I will describe a small Java utility that produces an Excel file. The Utility has a synchronous Rest API to act as an interface for callers.

Bear in mind that Oracle Integration Cloud has inbuilt capability to generate CSV files – CSV is a text-only format of comma/delimiter-separated values that can also be opened in a spreadsheet tool like Microsoft Excel or OpenOffice. However, Excel is a binary format capable of rich formatting, formulae, among other features.

The API that this post describes generates a proper well formatted Excel file, can be deployed in an Oracle PaaS environment on the Java Cloud Service (JCS),

can be consumed just like any other Rest service in the Oracle Integration Cloud (OIC), and can even be directly exposed to users (subject to security, usability, and other considerations).

The output

The output file generated by my sample Rest service can be seen below in a spreadsheet program like Microsoft Excel or OpenOffice Calc: Read the complete article here.

Developer Partner Community

For regular information become a member in the Developer Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook image Meetups

Technorati Tags: PaaS,Cloud,Middleware Update,WebLogic, WebLogic

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.