Excel Sheet: Difference between revisions
Jump to navigation
Jump to search
Removed redirect to Excel Tag: Removed redirect |
No edit summary |
||
| Line 1: | Line 1: | ||
Excel Sheet is an [[Item]] that stores data of an Excel File. | Excel Sheet is an [[Item]] that stores data of an [[Excel]] File. | ||
==Properties== | ==Properties== | ||
Revision as of 12:51, 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.
- Uploader name and date
- Warnings from Calculation
- Optional certification:
- Certificate Author
- Certificate Path
- Certificate State: NONE, CERTIFIED, UNCERTIFIED
Calculation
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
- The name of an Excel Sheet is limited to lowercase with underscores.
- Contrary to its name, an Excel Sheet item can hold the contents of an Excel file with multiple sheets.