example_of_data_access_from_excel_via_api
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext 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 atolstov | example_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]] | ||
+ | </ | ||
===== 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, | 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, | ||
- | Download the example {{ : | + | Download the example {{ network: |
< | < | ||
Line 63: | Line 67: | ||
- | Download the example {{ : | + | Download the example {{ network: |
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:// | 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:// | ||
- | Download the example: {{ : | + | Download the example: {{ network: |
example_of_data_access_from_excel_via_api.1620808356.txt.gz · Last modified: 2021/05/12 08:32 by atolstov