Querying

QueryStorm supports writing SQL and C# scripts that can see Excel tables, and work with data as if it was in a database or a .NET collection.

Tables, not sheets

It's important to note that QueryStorm scripts work with Excel tables, and not with ranges or sheets.

Press Ctr+T on a cell or a block of cells to convert it to a table.

SQL querying

QueryStorm comes with a built-in SQLite engine that can work with workbook tables as if they were regular database tables.

You can run any valid SQLite query on your data, including UPDATE, INSERT and DELETE statements.

Visit the SQLite section for more information.

External databases

Aside from the built-in SQLite engine, you can also connect to external databases. As you connect, you can choose which tables will be imported into the database as temp tables and thus made available to your scripts. This makes it very easy to move data between Excel and databases.

Read more about working with external databases here.

Querying with C#

QueryStorm also allows querying data via C#. Tables are represented as collections of strongly typed objects that you can query and modify.

Types that represent table rows are dynamically generated, allowing for strongly-typed access to the data. Any changes you make to your workbook tables (e.g. adding a new column or a table) are immediately reflected in your C# scripts.

Read more about QueryStorm's C# scripting support here.