Excel Sheet: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
==Properties== | ==Properties== | ||
An Excel Sheet | An Excel Sheet item has the following properties: | ||
* Byte array of the Excel File contents | * Byte array of the Excel File contents | ||
* Name of the file; Limited to lowercase with underscores. | * Name of the file; Limited to lowercase with underscores. | ||
| Line 13: | Line 13: | ||
==Simulation Core Instances== | ==Simulation Core Instances== | ||
A single Excel Sheet can be referenced by multiple [[Panel]]s and [[Indicator]]s. Indicator and Panel calculators can fill their instance of an Excel Sheet with their specific TQL Queries. | A single Excel Sheet can be referenced by multiple [[Panel]]s and [[Indicator]]s. Indicator and Panel calculators can fill their instance of an Excel Sheet with their specific TQL Queries. A specific TQL query example is: <code>SELECT_NAME_WHERE_INDICATOR_IS_ID</code> | ||
{{article end | {{article end | ||
Revision as of 13:41, 12 October 2026
Excel Sheet is an Item that stores data of an Excel File.
Properties
An Excel Sheet item has the following properties:
- Byte array of the Excel File contents
- Name of the file; Limited to lowercase with underscores.
- Uploader name and date
- Warnings from Simulation Core
- Optional certification:
- Certificate Author
- Certificate Path
- Certificate State: NONE, CERTIFIED, UNCERTIFIED
Simulation Core Instances
A single Excel Sheet can be referenced by multiple Panels and Indicators. Indicator and Panel calculators can fill their instance of an Excel Sheet with their specific TQL Queries. A specific TQL query example is: SELECT_NAME_WHERE_INDICATOR_IS_ID
Notes
- Contrary to its name, an Excel Sheet item can hold the contents of an Excel file with multiple sheets.
- An Excel Sheet cannot be removed while it is referenced by a Panel or Indicator.
How-to's
See also
API Endpoints