Skip to main content
Question

IFS Cloud Write XML Content into Excel File


SAMLK
Hero (Partner)
Forum|alt.badge.img+13
  • Hero (Partner)
  • 227 replies

Hi Experts,

I have a basic question regarding generating Excel file output from IFS Cloud table data.

We’ve already developed a customization that writes the table data into a CSV file using a CLOB and the Plsqlap_Server_API.Post_Outbound_Message method.

Now, there’s a new requirement to generate the output in Excel (.xlsx) format instead of CSV. Since I’m still new to IFS Cloud framework and integrations, I’d like to check whether this is achievable through a customization or if there’s a standard out-of-the-box (OOTB) way to handle this.

Your guidance would be greatly appreciated.

2 replies

SAMLK
Hero (Partner)
Forum|alt.badge.img+13
  • Author
  • Hero (Partner)
  • 227 replies
  • April 21, 2025

@dsj , ​@Charith Epitawatta do you have any idea on this?

I created a Java transformer that converts XML data into Excel using Apache POI libraries. I also created two other transformers that work fine for xml conversion formats like JSON and CDATA. However, when I try to generate an .xlsx file, it throws a NullPointerException in the application messages.

Any insights would be appreciated!


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 861 replies
  • April 22, 2025

Hi ​@SAMLK 

 

Have you tested the transformer locally if it generates the output in excel format as you intended?

Can you post the error stack from the application message? Hope it’s worth checking the exception fires within the transformer or somewhere else.

 

Cheers!

Damith


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings