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,
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
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 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
The WebRequest() function sends an HTTP or HTTPS request to a specified URL using either the GET or POST method and returns the response data.
The Unique() function returns the distinct rows from a range, preserving the order in which they first appear. Syntax: Examples: The examples provided below are
The TypeCast() function takes a data range as input and casts the columns or rows of that range according to a specified list of data
View More