OnFileReceived - Excel Workbook

You can use the Apache POI libraries embedded into Ignition to do this. Take the event's file bytes, wrap with a ByteArrayInputStream and feed it to the POI library. You get an in-memory spreadsheet from which you can extract any arbitrary sheets and cell values (or iterate through them).

Start here:

1 Like