Difference between revisions of "XL3Jsonify"
(→Examples) |
|||
| Line 25: | Line 25: | ||
''Rows of the $D$7:$K$12 range for which the cell value is equal to TRUE for the same row in the $L$8:$L$12 range are returned as a JSON string.'' | ''Rows of the $D$7:$K$12 range for which the cell value is equal to TRUE for the same row in the $L$8:$L$12 range are returned as a JSON string.'' | ||
| + | [[File:01 XL3Jsonify.png|center]] | ||
| + | |||
| + | [[File:02 XL3Jsonify.png|center]] | ||
==See Also== | ==See Also== | ||
Revision as of 15:58, 8 April 2024
XL3Jsonify transforms an array into a JSON string. The source array can optionnaly be filtered on the basis of a column tracking changed values (used in conjunction with XL3TrackChanges). XL3Jsonify is often used as an argument for XL3RunSQLProc2 to pass a JSON structure to an SQL Stored Procedure.
Contents
[hide]Syntax
XL3Jsonify( Input, Filter )
Parameters
| Parameter | Description |
|---|---|
| Input | The range to watch for changes. |
| Filter | The range (column) that contains TRUE values to corresponding changed rows. |
Examples
Rows of the $D$7:$K$12 range for which the cell value is equal to TRUE for the same row in the $L$8:$L$12 range are returned as a JSON string.
