Import data from excel inside the table component

You can use a File Upload component to get the Excel File into Ignition. In the file received event, you would push the file bytes into the Apache POI libraries, from which you can loop through the workbooks sheets and rows and columns however you like. But you have to write some jython.

Various discussions of how to do this, with scattered examples:

https://forum.inductiveautomation.com/search?q=file%20upload%20apache%20poi%20order%3Alatest

If you'd like to study a particularly complex example, you may find this interesting:

1 Like