Excel Sheet

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

• How to prepare data in Microsoft Excel

See also

• Excel
• Indicator
• Excel Panel

API Endpoints

• Api session items excelsheets
• Api session event editor excelsheet

---

Indicators

Basics

Excel • Excel Sheet • Indicators Tutorial • TQL • TQL Tutorial

Public Share

Climate adaptation • Green • Green MKP • Health • Heat Reduction • Heat risk • Housing target • Industrial runoff • Livability Housing • Parking • Risk contour • Solar panels • Student housing target • Traffic health impact • Traffic Noise • Water stress • Wind turbine

Tools

Chat Channel • HTML • JavaScript • Plotly