App Store Wiki

User Tools

Site Tools

Trace:
excel:ui

Differences

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

Link to this comparison view

Next revision		Previous revision
excel:ui [2018/07/31 11:46] – created suexcel:ui [2022/08/17 15:40] (current) – [Advanced] su
Line 4: Line 4:
  
 ==== Get Current Value ==== ==== Get Current Value ====
 +{{:excel:ip_query_-_current_value_icon.png?400|}}
  
-Clicking "Get Current Value" allows you to configure a request to get the current value for some tags. +Clicking "Current Value" allows you to configure a request to get the current value for some tags. 
   * Select the relevant data source    * Select the relevant data source 
   * Enter a filter to search for tags available from that data source and click "Search"   * Enter a filter to search for tags available from that data source and click "Search"
Line 17: Line 18:
  
 ==== Get Historical Values ==== ==== Get Historical Values ====
 +{{:excel:ip_query_-_historical_values_icon.png?400|}}
  
-Clicking "Get Historical Values" allows you to configure a request to get the historical values for some tags. +Clicking "Historical Values" allows you to configure a request to get the historical values for some tags. 
   * 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 for the query+  * Enter the start time, end time, interval and data function for the query
   * 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't support tag read operations or you aren't authorized to read from the data source. If the data source you want to query isn't listed it may be because it's not authorized, it doesn't support tag read operations or you aren't authorized to read from the data source.
 +
 +==== Refresh Data ====
 +
 +{{:excel:ip_query_-_refresh_data_icon.png?400|}}
 +
 +This button will reload all data query formulas in the currently opened sheet.
 +
 +==== Refresh Selection ====
 +
 +{{:excel:ip_query_-_refresh_selection_icon.png?400|}}
 +
 +This button will reload all data query formulas in the currently selected range.
  
 ==== Write Data ==== ==== Write Data ====
 +
 +{{:excel:ip_query_-_write_data_icon.png?400|}}
  
 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 43: Line 59:
 If you don't see the data source you want to write to listed it may be because it's not authorized, it doesn't support write operations or you don't have permission to write to that data source. If you don't see the data source you want to write to listed it may be because it's not authorized, it doesn't support write operations or you don't have permission to write to that data source.
  
-=== Advanced === 
  
-All text boxes can will be evaluated as a formula if they begin with "="+==== Write All ====
  
-You can use the "Custom Tag" box to add tags that aren't listed, this is primarily useful if you want to query Alarm Analysis Meta tags.+{{:excel:ip_query_-_write_all_icon.png?400|}}
  
-Deselect "Enter As Formula" if you would like the result of the query to be added directly to the sheet. Leaving it selected generates a formula as described in the "Using Data Query Formulas" section+The write all button allows you to write multiple values to multiple tags instantly.
  
-==== Refresh Data ====+In order for this to work you must setup the workbook to have certain defined names. To setup a defined name:
  
-This button will reload all data query formulas in the currently opened sheet.+  - Open the workbook 
 +  - Click the "Formulas" tab 
 +  - Click "Define Name" in the "Defined Names" section 
 +  - Enter the name of the defined name 
 +  - Enter the value of the defined name in the "Refers to" input box 
 +  - Click "OK"
  
-==== Refresh Selection ====+You can edit these names later by clicking "Name Manager" then selecting a name and clicking "Edit"
  
-This button will reload all data query formulas in the currently selected range.+To configure the "Write All" action created the following defined names:
  
-=== Wiki ===+  * **DataSource** - The fully qualified name of the data source that should be written to 
 +  * **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 
 +  * **CurrentValues** - [Optional] The range of cells that contains queries to the effected tags (so that they can be reloaded automatically) 
 + 
 +Each value in the Values range will be written to the corresponding tag in the Tags range. Tags whose corresponding Values  cell is empty will be ignored. 
 + 
 + 
 +==== Wiki ==== 
 + 
 +{{:excel:ip_query_-_wiki_icon.png?400|}}
  
 This button will open the add-in wiki. This button will open the add-in wiki.
 +
 +===== Advanced =====
 +
 +All text boxes can be evaluated as a formula if they begin with "="
 +
 +You can use the "Custom Tag" box to add tags that aren't listed, this is primarily useful if you want to query Alarm Analysis Meta tags.
 +
 +Deselect "Enter As Formula" if you would like the result of the query to be added directly to the sheet. Leaving it selected generates a formula as described in the "Using Data Query Formulas" section
  
excel/ui.1533037610.txt.gz · Last modified: 2018/07/31 11:46 by su