Reading Excel file through the Generic Java Driver

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf Reading Excel file through the Generic Java Driver

  • Creator
    Topic
  • #55496
    Jerry Tilsley
    Participant

      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

    Viewing 1 reply thread
    • Author
      Replies
      • #85552
        Robert Milfajt
        Participant

          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

        • #85553
          Jerry Tilsley
          Participant

            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

        Viewing 1 reply thread
        • The forum ‘Cloverleaf’ is closed to new topics and replies.