Query an Excel using SQL
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 | |
| Output filename | Optional custom filename for the output Excel file | Text(Long) | No | sample.xlsx |
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