Returning Multiple Cell Results From Extended Functions

Many AlchemyJ Extended Functions can return results across multiple cells. For example, ajExecuteSql can return a list of records from a SQL query. The retrieved records are usually returned as a matrix like those shown in the below screenshot. On the other hand, ajMakeJson returns a JSON string. However, the JSON string may be too long for one cell to show so the result will span across multiple cells.

AlchemyJ uses array formula in Excel to specify such behavior. When entering an AlchemyJ Extended Function that is expected to return a multiple-cell result, select the range that the result should be shown, e.g, B4:F8 input the formula and press CTRL+SHIFT+ENTER.

Please note that the current version of AlchemyJ does not support the standard Excel array formulas yet. When using array formula for AlchemyJ Extended Function, remember not to add other Excel standard functions around it. For example: {IFERROR(ajPopulateJsonToTable(A4:D4, B2), "")} will not work.