Excel Sheet

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

• How to prepare data in Microsoft Excel
• How to create an Excel Sheet using the add matrix endpoint

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