ajRenderTextWithJSON function
Available since AlchemyJ v4.3 AlchemyJ Enterprise Edition
Description
The ajRenderTextWithJSON function render Text by providing Data Relationship Schema and Freemarket template file.
Syntax
ajRenderTextWithJSON(json_data,template_path,[split_lines],[options],[run_condition],[run_by_function_point_only])
| Argument Name | Argument Type | Description |
|---|---|---|
| json_data (required) | Variant | To specify the range where defines the header of the relationship table. |
| template_path (required) | String | To specify FTL template location |
| split_lines (optional) | Boolean | TRUE would return the output in multiple cells based on \n, \r (expand to multiple rows) . The default value is False. |
| options (optional) | Variant | Define a list of options that the FTL / PDF library supports. |
| run_condition (optional) | Boolean | The function will run when the value is TRUE. Otherwise will not run. The default value is TRUE. |
| run_by_function_point_only (optional) | Boolean | If it equals FALSE, the function can be executed through ‘Excel Calculation’ (can be either Automatic or Manual, Calculate Now or Calculate Sheet) or Preview Function Point. If it equals TRUE, the function can be executed with Preview Function Point (AlchemyJ ribbon \ Preview Function Point) only. The default value is TRUE. |
The function will return:
1) Return Value: TRUE, #VALUE!
2) Return Type: Single Value
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type. Besides, system will raise error for below scenario(s).
| Error Scenarios |
|---|
| Data cannot be empty. |
| Template path cannot be empty. |
| File location cannot be empty. |