Excel Sheet: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| 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