xpna.DATAGRID FUNCTION
Usage
The DATAGRID function is the in-sheet engine behind xpna DataGrids.
The DATAGRID will output in one of two ways.
Where a destination is not specified, from the cell that it is in, it will create an Excel Spill range that contains the specified DataGrid.
Where the destination is supplied, an Excel Table will be created or updated with the output.
Whilst you can compose these functions yourself, we recommend that you use the Manage DataGrid interface to create and edit them which is accessible as acontext aware action
Syntax
| Argument | Description |
|---|---|
| gridName | The name of the xpna DataGrid to return. |
| destination | The cell reference or named range for where to output the DataGrid. If not provided the grid will create a spill range from the current cell. (optional) Note: It is best to use the xpna.INFO("address", <ref>) formula here so that a valid reference is used by the DATAGRID formula.If using the Manage DataGrid interface, this helper formula will be used if possible |
| [arg1..argN] | The applicable argument value for the grid selected, or if allowed by the DataGrid definition, filters. (optional) |
Common Problems
- The function will return an error if you do not provide at least a grid name.
- Where no other arguments are passed, sensible defaults will be used to return the DataGrid