Illustrated in the below image is a flow where the Excel Raw reader step is used to read the data from the Excel file, the Filter step is being used to filter for a specific sheet from the Excel file and a Buffer destination step to store the Excel data in.
The below image is the configuration of how you want the data to return. Leave the Worksheet field blank if you want to return all the data from all the sheets. The Smart format is selected as the Raw Format in this example.
Adding an Excel Reader step
To use an Excel Reader step in a flow, please follow the instructions below:
1. Click on the highlighted icon as shown in the below image.
2. The below page will appear. Select or search for a Reader step to retrieve the source data. Click on the Reader tab and select Excel Raw as shown in the image below.
The image below shows the Excel Raw page.
How to use the Excel Raw Reader step
The image below shows the data in a sheet in an Excel file.
To view the data from the worksheets in an Excel file, please follow the below instructions:
1. Click on the play button on the Excel Raw reader step as highlighted in the image below:
2. Click the highlighted are in the image below to upload an Excel file.
3. Click the Test button as shown in the image below.
The output for the Smart Raw Format is shown in the below page.
The image below shows the code that is used in the Filter step to filter the a sheet from the Excel file. A Calculator step is added after the Filter step to test and view the data that gets returned after the Filter Step.
The below image shows how the values in the buffer will look. In addition, it also stores the sheet names.
Additional Information:
If “Label” is selected as the Raw Format in the Excel Raw reader step, the data will be returned as per the below image.
If “2D Array” is selected as the Raw Format in the Excel Raw reader step, the data will be returned as illustrated in the below images.
