parse xls/x to array

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

parse xls/x to array v13.0.5

Parses a xls / xlsx file and returns the first worksheet as an array.

In pins 3 + flow
  • flow
    flow
  • file required
    file

    The file to be parsed.

  • parse options
    object

    The options to be used during parsing.

  • conversion options
    object

    The options to be used during conversion.

Out pins 3 + flow
  • flow
    flow
  • success
    condition
  • error
    value
  • array
    array

    The parsed worksheets used in the Excel.

Excel

A typical wiring for parse XLS/X to array: a function trigger starts the flow; get file from assets feeds the file pin; the flow out pin feeds debug.

Studio canvas example for the parse XLS/X to array block: typical wiring for parse XLS/X to array.

Used in these guides

These documentation pages use or explain this block:

Version history

Introduced in v13.0.5.


Back to files Return to the main group to view all sub-groups Back to file parsing Return to the group to view all blocks within this group