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 block of data and is often used to create reports consisting of multiple parts.
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 retrieves data from a URL. Syntax WebRequest() Note: Input parameters can consist of Quintessence functions. This includes functions that return ranges in
The Unique() function returns the distinct rows in a range, in the order in which they occur. Syntax Unique (Range) Range The range of cells
The TypeCast() function takes a range as input and casts the columns or rows of that range according to a list of data types. The
The TransposeArray() function returns the transpose of a range (vertical columns are returned as horizontal rows or vice versa). Related functions: ArrayToString, StringToArray, SubstituteArray Syntax
The Transform() function takes a range of information and performs calculations on that information. In its simplest form, Transform() can be used to reorder columns
View More