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
Next revision
Previous revision
example_of_data_access_from_excel_via_api [2021/05/12 08:32] – ↷ Page name changed from example_of_data_access_from_excel to example_of_data_access_from_excel_via_api 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 1: Line 1:
 ====== An example of getting WebHMI data from Excel ====== ====== An example of getting WebHMI data from Excel ======
 +
 +<WRAP center round info 60%>
 +There is a detailed explanation about this functions [[access_via_api|here]]
 +</WRAP>
  
 ===== Getting data from event log===== ===== Getting data from event log=====
Line 5: 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 63: 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 146: 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.1620808356.txt.gz · Last modified: 2021/05/12 08:32 by atolstov

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki