XLSX Expand

XLSX Expand (xlsx)

Expand Microsoft Excel worksheets into individual events or CSV-like structures.

Transform binary json

Minimal example

actions:
  - xlsx: {}

JSON

{
  "actions": [
    {
      "xlsx": {}
    }
  ]
}

Contents

• Minimal example

• Advanced

• General

• Output

• Selection

A ✓ marks a field that accepts a context variable such as {{ VARIABLE }}.

Advanced

Advanced

Field	Type	Required	Description
emit-document-events ✓	boolean (bool)		Emit an additional document-level event per spreadsheet. Default: false

General

General

Field	Type	Required	Description
description	string		Short summary describing how this expand step is used.
condition	lua-expression (string)		Conditional expression that must be true for the action to run. Examples: 2 * count()

Output

Output

Field	Type	Required	Description
delimiter	string		Delimiter to use when emitting CSV-like rows.

Selection

Selection

Field	Type	Required	Description
sheet-name	string		Name of the worksheet to expand (takes precedence over index).
sheet-index	number (integer)		Zero-based worksheet index to target when sheet_name is unset. Examples: 42, 1.2e-10