Skip to main content

ImportFromExcel@1

Node ImportFromExcel@1 is used to import data from an Excel file. This node is useful when you want to import data from an Excel file and use it in the pipeline.

note

This node is used by the Excel Add-In to import data from an Excel file.

Adapter Prerequisites​

Node Configuration​

Fields path, targetPath, targetValueWriteMode, and targetValueKind are unavailable for this node.

transformations:
  - type: ImportFromExcel@1 # Import data from an Excel file, no configuration required

The payload is custom to the Excel Add-In and is not documented here.

Example​

The following example shows how to import data from an Excel file. This pipeline is triggered by an HTTP request and imports data from an Excel file.

triggers:
  - type: FromHttpRequest@1
    path: /import/tree
    method: POST
transformations:
  - type: ImportFromExcel@1