excel:ui
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
excel:ui [2018/08/01 15:31] – Added explanation of the write all button su | excel:ui [2022/08/17 15:40] (current) – [Advanced] su | ||
---|---|---|---|
Line 4: | Line 4: | ||
==== Get Current Value ==== | ==== Get Current Value ==== | ||
+ | {{: | ||
- | Clicking "Get Current Value" allows you to configure a request to get the current value for some tags. | + | Clicking " |
* Select the relevant data source | * Select the relevant data source | ||
* Enter a filter to search for tags available from that data source and click " | * Enter a filter to search for tags available from that data source and click " | ||
Line 17: | Line 18: | ||
==== Get Historical Values ==== | ==== Get Historical Values ==== | ||
+ | {{: | ||
- | Clicking "Get Historical Values" | + | Clicking " |
* Select the relevant data source | * Select the relevant data source | ||
* Enter a query to search for tags available from that data source | * Enter a query to search for tags available from that data source | ||
* Select the tag(s) you would like to query | * Select the tag(s) you would like to query | ||
- | * Enter the start, end times, interval and data funciton | + | * Enter the start time, end time, interval and data function |
* Enter the number of points (e.g. a 10 day query with interval 1h is 240 points) | * Enter the number of points (e.g. a 10 day query with interval 1h is 240 points) | ||
* Select whether you would like a header row and time stamps | * Select whether you would like a header row and time stamps | ||
Line 30: | Line 32: | ||
If the data source you want to query isn't listed it may be because it's not authorized, it doesn' | If the data source you want to query isn't listed it may be because it's not authorized, it doesn' | ||
+ | |||
+ | ==== Refresh Data ==== | ||
+ | |||
+ | {{: | ||
+ | |||
+ | This button will reload all data query formulas in the currently opened sheet. | ||
+ | |||
+ | ==== Refresh Selection ==== | ||
+ | |||
+ | {{: | ||
+ | |||
+ | This button will reload all data query formulas in the currently selected range. | ||
==== Write Data ==== | ==== Write Data ==== | ||
+ | |||
+ | {{: | ||
Clicking "Write Data" allows you to write a value to a tag in a data source. | Clicking "Write Data" allows you to write a value to a tag in a data source. | ||
Line 45: | Line 61: | ||
==== Write All ==== | ==== Write All ==== | ||
+ | |||
+ | {{: | ||
The write all button allows you to write multiple values to multiple tags instantly. | The write all button allows you to write multiple values to multiple tags instantly. | ||
Line 64: | Line 82: | ||
* **Tags** - The range of cells that contains the tag names you want to update | * **Tags** - The range of cells that contains the tag names you want to update | ||
* **Values** - The range of cells that contains the new values of the tags | * **Values** - The range of cells that contains the new values of the tags | ||
- | * **CurrentValues** - [Optional] The range of cells that contains queries to the effected tags (so that they can be reloaded | + | * **CurrentValues** - [Optional] The range of cells that contains queries to the effected tags (so that they can be reloaded |
Each value in the Values range will be written to the corresponding tag in the Tags range. Tags whose corresponding Values | Each value in the Values range will be written to the corresponding tag in the Tags range. Tags whose corresponding Values | ||
- | ==== Refresh Data ==== | ||
- | |||
- | This button will reload all data query formulas in the currently opened sheet. | ||
- | ==== Refresh Selection | + | ==== Wiki ==== |
- | This button will reload all data query formulas in the currently selected range. | + | {{: |
- | + | ||
- | ==== Wiki ==== | + | |
This button will open the add-in wiki. | This button will open the add-in wiki. | ||
Line 82: | Line 95: | ||
===== Advanced ===== | ===== Advanced ===== | ||
- | All text boxes can will be evaluated as a formula if they begin with " | + | All text boxes can be evaluated as a formula if they begin with " |
You can use the " | You can use the " |
excel/ui.1533137499.txt.gz · Last modified: 2018/08/01 15:31 by su