Reading Excel file through the Generic Java Driver

[Jerry Tilsley]

All,

I am wanting to receive an Excel file through the Cloverleaf server and then open that file with the Generic Java Driver.  I’ve created the code that will open an excel file, but what we get on the Cloverleaf side is either a binary encode string or a byte array.  Anyone ever done something like this?  Just need to somehow get the message data into a format that can be opened by the Apache POI XSSFWorkbook class.

Thanks,

Jerry

Topic

[Robert Milfajt]

Simplest would be to have source system or your code to save file as csv and then you can just use like a normal text file.

Robert Milfajt
Northwestern Medicine
Chicago, IL

[Jerry Tilsley]

I ended up using the UPoC protocol and attaching a class that will scan a directory and picking up any Excel files.  These are then turned into CSV files before the engine touches them.  Seems to work well.

Jerry

[Author]

Replies