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

• Fields

• General

• Selection

• Output

• Advanced

Fields

Field	Type	Required	Description
description General	string		Short summary describing how this expand step is used.
condition General	lua-expression (string)		Conditional expression that must be true for the action to run. Examples: 2 * count()
sheet-name Selection	string		Name of the worksheet to expand (takes precedence over index).
sheet-index Selection	number (integer)		Zero-based worksheet index to target when sheet_name is unset. Examples: 42, 1.2e-10
delimiter Output	string		Delimiter to use when emitting CSV-like rows.
emit-document-events Advanced	boolean (bool)		Emit an additional document-level event per spreadsheet.

General

Show fields

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()

Selection

Show fields

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

Output

Show fields

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

Advanced

Show fields

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