If you want to exchange data between a PLC and Excel, it often happens that both directions are configured with identical structure.
For example, you load a recipe from an Excel file into the PLC and then want to write changes that were made via the panel back into the Excel file.
To facilitate this configuration, there is the possibility to invert all Excel actions in the trigger. This means that a reading action is converted to the appropriate writing action. All assignments of cells and PLC variables are taken over accordingly.
So, for example, if you have already configured a trigger that writes data from the PLC to Excel, you can copy this trigger and then invert all Excel actions in the copy without resetting the individual assignments.
The button for inverting an Excel action can be found in the respective header of the action in the configuration page of the trigger.
