Retrieve data from Excel | Wrk Automation Documentation

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 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: Text Number Integer True/False Link Date	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 headers If 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

Retrieve data from a row in Google Sheets

Retrieve data from Google Sheets

Retrieve text from Google Docs

Retrieve data from a PDF file (Human)

Perform an API call in Microsoft 365 Excel