Retrieves data from an Excel file's worksheet. Data should be organized as a table with column headers in the first row. Every row other than the headers represents a set of data to be captured. The outputs should be configured by the user in the "Fields to capture" section and should match the headers of the worksheet.
Application
Microsoft Excel
Inputs (what you have)
NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
Excel file | Excel file to capture the data from | Text | Yes | File-1 |
Worksheet name | Name of the worksheet to capture data from | Text | No | Sheet1 |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data library section. These variables in the Data library section are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
To be defined | The outputs will be defined by the user within the Fields to capture section. | Any of the following:
| Yes |
|
Outcomes
NAME | DESCRIPTION |
Success | This status is selected if the data is successfully retrieved from the worksheet in Excel. |
Information Missing | This status is selected in the event of the following scenarios:
|
Unsuccessful | This status is selected in the event of the following scenarios: |
Requirements
Add the file in the Wrkflow seeding card
The data within the spreadsheet should be properly formatted