I am working on a conversion project and there is functionality in the old system that reads/writes live data between the HMI and excel. Is there a way to do that in Ignition?
I have been able to write data from Ignition to an Excel worksheet, but I had to write a custom module to add the Apache POI classes to Ignition. Please see the following post:
When making the module, make sure to include the correct version that the Reporting module uses, or it will not work.
As a side note, if you don’t have the reporting module you can probably just add the JAR file as described in the post above.
If you want a module that is already made there is one on the module marketplace: