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
View More