Wrk Action Library
Retrieve data from a row in Excel
Bot
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.
Inputs: Excel file and row number
Outputs: Configured in the "Fields to capture" section
Outcomes: Success
$0.005 / result
Retrieve data from Excel
Bot
Retrieve 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.
Inputs: Excel file and fields to capture
Outputs: Row number and configured in the "Fields to capture" section
Outcomes: Success or no result
$0.005 / result
Search value location in Excel Worksheet
Bot
Find and return all locations of a specified value within a sheet of an Excel Workbook.
Inputs in this Wrk Action use wildcards: Question mark (?) matches any one character, asterisk (\*) matches zero or more characters. To search for a wildcard value, add a tilde (~) before the wildcard character
Inputs: Excel file and search value
Outputs: Column letter, row number and cell location
Outcomes: Success or no result
$0.01 / result