Skip to main content

Retrieve data from a row

Retrieve data from a specific row in an Excel Spreadsheet. 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.

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 "Custom Outputs" section and should match the headers of the worksheet.

Application​

  • Microsoft Excel

Inputs (what you have)​

NAMEDESCRIPTIONTYPEREQUIREDEXAMPLE
Excel fileExcel file to capture the data fromTextYesFile-1
Worksheet nameName of the worksheet to capture data from Note: First worksheet will be used by default. Worksheet name is case sensitive.TextNoSheet1

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)​

NAMEDESCRIPTIONTYPEREQUIREDEXAMPLE
To be definedThe outputs will be defined by the user within the Custom Outputs section.Any of the following:TextNumberIntegerTrue/FalseLinkDateYes

Outcomes​

NAMEDESCRIPTION
SuccessThis status is selected if the data is successfully retrieved from the worksheet in Excel.
Information MissingThis 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
UnsuccessfulThis 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