Is there something equivalent to this code for uploading a workbook from excel vs a .csv fileContent = event.file.getString() # Create a CSV reader reader = csv.reader(io.StringIO(fileContent)) I want to be able to directly access a workbooks data in the onFileReceived event. I have a project libr…

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 h…

OnFileReceived - Excel Workbook

Ignition

dkhayes117 December 19, 2023, 7:48pm 13

You didn't do this?