You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

conversion of .xlsx to .csv using OIC

in Integration 3 comments

Summary:

We're seeking solutions or suggestions for reading content from an Excel (.xlsx) file in Oracle Integration Cloud (OIC), as OIC currently lacks a standard adapter for this file type. Here are some alternate methods we've explored:1. File Conversion to CSV: Renaming the .xlsx file to .csv in OIC's staging area, but this approach corrupts the file content. Without an Excel adapter, repairing it within OIC isn't possible.2. Using Python Code: We've considered Python scripts to convert the file, but OIC can't trigger .bat or .py files directly from a VM.3. Oracle Functions in OCI: This method works, but deployment in

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!