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,

The IsDefined() function determines whether an input parameter has a value assigned to it or not. Related functions: IsDate, IsElement, IsNull Syntax IsDefined (Element) Element

The Quintessence language functions are useful ‘parser-type’ functions that are available in the Quintessence Application. They can also be used within expressions in Excel. Maths

The Top() function returns the first element of an array. Related functions: Bottom Syntax Top (Array, No of rows) Array The input array No of

The SubStr() function returns part of a string. Note: SubStr() is an old function that is interchangeable with the Excel Mid() function. Mid() should be

The Str() function converts a numeric value to a string. Syntax Str (Value) Value Any value Examples Function Output Str(1.356) “1.356” Str(True) “True” Str(ABC) “ABC”

The StartsWith() function evaluates whether an input string starts with a specified set of characters. Related functions: EndsWith Syntax StartsWith (SpecifiedElement, Value) SpecifiedElement The input

The Split() function returns an array of strings from a single input, by separating the input string using a specified delimiter. Syntax Split (String, Delimiter)