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
| 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 Note: First worksheet will be used by default. Worksheet name is case sensitive. | 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:TextNumberIntegerTrue/FalseLinkDate | 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:If the first row does not contain column headersIf it is not clear which column header belongs to a field defined |
| Unsuccessful | This status is selected in the event of the following scenarios: - No excel file provided in data library |
Requirements
- Add the file in the Wrkflow seeding card
- The data within the spreadsheet should be properly formatted