Skip to content

Welcome to QueryStorm

This document is a 2-minute introduction to help you quickly get started with QueryStorm.

Tables, not sheets

QueryStorm works with Excel tables (not sheets). This is an important distinction, so I mention it a few more times throughout this documentation.

Tables

Note

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

Querying with SQL

Once you have the data in tables, you can start querying by clicking Connect (SQLite) in the ribbon. This will pop up the QueryStorm IDE and open a SQLite connection that sees Excel tables as database tables.

Querying with SQL

The database engine is SQLite and you can run any valid SQLite query on your data, including UPDATE, INSERT and DELETE statements. You can even change row formatting via SQL.

Read more about the SQL support here.

Querying with C#

Aside from SQL, you can also query data via C#. Click the Connect (C#) button in the ribbon to open the IDE and start an interactive C# session. Excel tables will show up as strongly typed collections that you can query and modify. Named ranges will also show up as strongly typed variables which you can use to get/set the values of the named ranges.

Querying with C#

Read more about QueryStorm's C# support here.

Connecting to external databases

You can connect to external databases and move data in either direction. This makes importing, exporting and combining database and spreadsheet data much easier.

To connect to an external database, click Connect custom. A dialog will appear allowing you to choose (or define) a database connection:

Defining a connection

While setting up the connection, you select which Excel tables need to be visible to the database. These tables are copied to the database as temp tables as soon as the connection is established.

Connected to DB

You can now query the data from Excel tables alongside permanent database tables, using all the resources of the database server. Query results can easily be returned into Excel and used to populate tables or ranges.

Read more about working with external databases here.

Try it!

Congratulations, you now know the basics of QueryStorm. There's a lot more interesting stuff in the rest the documentation and some video tutorials as well, so I encourage you to take a look.

Comments