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),
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.
For regular information become a member in the Developer Partner Community please register here.