Query an Excel using SQL. Wrk Action uses SQLite syntax. Note: Only basic SELECT and JOIN statements are supported. Please refer to the documentation for more details on configuration.
Application
Microsoft Excel
Inputs (what you have)
Name | Description | Data Type | Required? | Example |
Excel file | Excel file you would like to query using SQL | File | Yes | |
SQL query | A SQL query to perform on the provided Excel. Example: `Select * from Sheet2` | Text (Long) | Yes | Select * from Excel |
Columns do not have headers? | If selected, the headers will be referred to as Col1, Col2, etc. All sheets | True/False | No | |
Use sheet index? | Set to true to use sheet index (`Sheet2`) for table names instead of sheet name | True/False | No |
Outputs (what you get)
Name | Description | Data Type | Required? | Example |
Output Excel | Output Excel file | File | Yes | |
Output JSON | JSON output of the query result | Text (Long) | No | |
Total number of rows | The total number of rows in the output Excel | Number | No |
Outcomes
Name | Description |
Success | This status is selected if the job has successfully completed. |
Requirements
N/A