OBJECT (PQL - xl)
The OBJECT function is used to define an object, and specify the props and values. The OBJECT function result will be an object of these props and values
- Library: PQL \ Spreadsheet \ Text
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
OBJECT(property1, expression1, property2, expression2)
Function Arguments
Name | Description | Type | Optional |
property1 | Refers to the first property of current object. It can be a string or a cell reference | String |
|
expression1 | Refers to the first property value of current object. It can be any type value or a cell reference | StringOrNumber |
|
property2 | Refers to the second property of current object. It can be a string or a cell reference | String |
|
expression2 | Refers to the second property value of current object. It can be any type value or a cell reference | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'OBJECT' function - using the same inputs, logic and outputs.