User Tools

Site Tools


example_of_data_access_from_excel_via_api

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
example_of_data_access_from_excel_via_api [2021/05/12 08:35] atolstovexample_of_data_access_from_excel_via_api [2022/01/15 20:39] (current) – ↷ Links adapted because of a move operation 127.0.0.1
Line 9: Line 9:
 Below is a simple example of a query from Excel to the WebHMI API. In this example, data is read from the event log. This example uses an Active-X object and works only on Windows platforms. Additionally, a library is used for parsing JSON responses. Below is a simple example of a query from Excel to the WebHMI API. In this example, data is read from the event log. This example uses an Active-X object and works only on Windows platforms. Additionally, a library is used for parsing JSON responses.
  
-Download the example {{ :api_example.zip |API Example.xlsm}}+Download the example {{ network:api_example.zip |API Example.xlsm}}
  
 <code> <code>
Line 67: Line 67:
  
  
-Download the example {{ :webhmi_registers_read_and_write.zip |WebHMI registers read and write.xlsm}}+Download the example {{ network:webhmi_registers_read_and_write.zip |WebHMI registers read and write.xlsm}}
  
  
Line 150: Line 150:
 The third example shows how to read data for registers with ID = 1 and 21 from the logged during the last 10 minutes. This example uses the https://github.com/VBA-tools/VBA-Web library The third example shows how to read data for registers with ID = 1 and 21 from the logged during the last 10 minutes. This example uses the https://github.com/VBA-tools/VBA-Web library
  
-Download the example: {{ :webhmi_registers_log_read.zip |WebHMI registers log read.xlsm}}+Download the example: {{ network:webhmi_registers_log_read.zip |WebHMI registers log read.xlsm}}
  
  
example_of_data_access_from_excel_via_api.txt · Last modified: 2022/01/15 20:39 by 127.0.0.1

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki