Excel Sheet: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
An Excel Sheet items has the following properties: | An Excel Sheet items has the following properties: | ||
* Byte array of the Excel File contents | * Byte array of the Excel File contents | ||
* Name of the file. | * Name of the file; Limited to lowercase with underscores. | ||
* Uploader name and date | * Uploader name and date | ||
* Warnings from | * Warnings from [[Simulation Core]] | ||
* Optional certification: | * Optional certification: | ||
** Certificate Author | ** Certificate Author | ||
| Line 12: | Line 12: | ||
** Certificate State: NONE, CERTIFIED, UNCERTIFIED | ** Certificate State: NONE, CERTIFIED, UNCERTIFIED | ||
== | ==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. An example is of a specific TQL Query is: <code>SELECT_NAME_WHERE_INDICATOR_IS_ID</code> | 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. An example is of a specific TQL Query is: <code>SELECT_NAME_WHERE_INDICATOR_IS_ID</code> | ||
{{article end | {{article end | ||
|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]]. | |||
|seealso=*[[Excel]] | |seealso=*[[Excel]] | ||
*[[Indicator]] | *[[Indicator]] | ||
*[[Excel Panel]] | *[[Excel Panel]] | ||
| | |howtos=* [[How to prepare data in Microsoft Excel]] | ||
* | |api=*[[Api session items excelsheets]] | ||
*[[Api session event editor excelsheet]] | |||
}} | |||
}} | {{Indicator nav}} | ||
Latest revision as of 13:18, 30 September 2026
Excel Sheet is an Item that stores data of an Excel File.
Properties
An Excel Sheet items 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. An example is of a specific TQL Query 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