Excel Sheet: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| 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 | ||
| Line 22: | Line 22: | ||
*[[Excel Panel]] | *[[Excel Panel]] | ||
|howtos=* [[How to prepare data in Microsoft Excel]] | |howtos=* [[How to prepare data in Microsoft Excel]] | ||
* [[How to create an Excel Sheet using the add matrix endpoint]] | |||
|api=*[[Api session items excelsheets]] | |api=*[[Api session items excelsheets]] | ||
*[[Api session event editor excelsheet]] | *[[Api session event editor excelsheet]] | ||
Latest revision as of 13:56, 26 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