build xls/x

This block is part of the files group and was last modified in core v13.0.5.

build xls/x condition v13.0.5

Generates a xls / xlsx file.

In pins 6 + flow

flow
filename value required
The name of the file.
extension value required
The extension of the file, e.g. xls or xlsx.
headers array required
The headers will be used for the first row. If this is filled, the more advanced version (array of arrays) will be disabled. • Hidden when other fields are filled
values array required
The values to be set in the excel sheet. The headers will be used to select the data. If this is filled, the more advanced version (array of arrays) will be disabled. • Hidden when other fields are filled
array of arrays array required v13.0.5
This version allows for a more fine-grained control of what will be pushed to the worksheet. If this is filled, the headers and values will be disabled. • Hidden when other fields are filled
options object
The worksheet options

Out pins 3 + flow

Excel

A typical wiring for build XLS/X: a function trigger starts the flow; value feeds the filename pin; value feeds the extension pin; with values feeds the headers pin; with values feeds the values pin; with values feeds the aoa pin; the flow out pin feeds debug.

Used in these guides

These documentation pages use or explain this block:

Introduced in v13.0.5.