The output follows instructions with the cell or range to return.

for example: ["Sheet1!B1", "Sheet1!B2"]

Note that different from the input, the instruction is between brackets([]) and not braces({}). This is because you will not pass pairs of keys and values, only the address of the cells.

The output of XL Backend is passed as a list(or one-dimensional array) of strings. This is done so that different types can be passed in the same output. Type conversion needs to be performed by the nocode application. Several examples can be found in our demo apps.

Multicell Output

A great feature is that ranges of cells can be passed as output.

for example: ["Sheet1!B1:B2"]

In this case, each range listed in the output will be returned as one item of the array, and its individual cells will be passed in a list separated by commas. Therefore, two output ranges returning 1,2,3,4 and 5,6,7,8 respectively, will be returned as ["1,2,3,4","5,6,7,8"] and need to be treated upon reception.

The fact that cells are defined dynamically when your application calls the service and not static in our portal, opens for a much more flexible use, since you can change it in your app, changing the range of input and output programatically. We plan to record some videos with examples.

Last updated