Mango and Excel communication
-
Hi team,
I want to know that how to set up mango m2m to communicate with Ms Excel.
ie. my automation program is a n excel program (VBA) and I would like to use Mango as the modbus TCP gateway and Scada HMI.
for this reason I need to establish a communication between mango and excel for both data read and write.
I have done this previously with Siemens Desigo using Direct Data Exchange (DDE).
your support is highly appreciated
Kindest regards
Niro -
I think your best bet would be to use the RESTful API in Mango to allow Excel to query for data. I'm not very experience with Excel in this way but I know it is possible to connected to to a REST API.
-
Does this help? (Excel to Mango only but could be a starting point)
link text -
Thanks Joel
As always you are helpfulPD
-
Hay
that's awesome. do you also know any other way to push data from mango to excel?Thank you
PD