The Sparse() function, together with Excel’s implicit intersection operator (=@), allows the user to edit blank cells inside a returned result. When the function recalculates,

The ExportExcel() function takes a data block and exports it into an Excel workbook. The function can also append worksheets to existing Excel workbooks. This

The ExportCSV() function takes a data block and exports it into a CSV file. This function is only available in the Quintessence Language (for example,

Similar to CsvToArray, the ImportCsvText() function converts a block of CSV-formatted data into an array. However, this function also allows you to apply filter expressions

GlobalVariable() allows users to access variables configured by the administrator on a global level. These variables can be accessed from the Quintessence editor (from artifacts

Note: This is a legacy function and will be deprecated soon. Please use TimeSeries() instead.

Note: This is a legacy function and will be deprecated soon. Please use TimeSeries() instead.

The IsNullOrEmpty() function checks whether an element has no value assigned (i.e., it is null) or is an empty value. Unlike IsNull(), this function returns

Note: This function will be deprecated after version 25.1. Please use StringToArray instead.

The UpdateState() function is an Excel specific Quintessence function that returns a Boolean value indicating whether either the Upload Sheet or Upload Selected button was

TimeSeries is a sequence of data points, each consisting of a date and a value, associated with an entity and stored in the Quintessence database

JSON (JavaScript object notation) is a syntax for storing and exchanging data. Since the JSON format is text only, it can easily be sent to

The UploadDataAsync() function uploads data to Quintessence using a configured data feed. It processes the input range as is and bypasses any transformations. The async

ReportAsync() performs calculations in the background (asynchronously from Excel). This is useful for larger reports, allowing you to continue working in Excel while the report

ExecuteScheduleAsync() works the same way as the ExecuteSchedule() function, but runs in the background (asynchronously when called from third-party applications). This is useful for longer-running

Schedules are automated workflows that perform tasks on behalf of a user. They can be run directly from the Quintessence application or triggered programmatically using

The audit log captures data related to usage activity routed through Quintessence by users. The AuditLog() function retrieves records and relevant details for all requests

The Span() function arranges multiple blocks of data into a single combined block. It is commonly used to build reports consisting of multiple sections. Data

The Quintessence utility functions are available in both the Quintessence Excel® Addin and Quintessence Application. These functions perform useful manipulations on data. AlignToAxes ArrayToString Colouring

The XmlToArray() function converts a block of Xml formatted data to an Array. Syntax XmlToArray (Xml Input, Xml Mapping) Xml Input Raw Xml data used