Skip to main content

Query an Excel using SQL

Wrk Product avatar
Written by Wrk Product
Updated over a month ago

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

Did this answer your question?