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 important, so I might 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 into a table.

Querying with SQL

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

Querying with SQL

The database engine is SQLite and you can run any valid SQLite query on your data. You can even change row formatting via SQL.

Read more about the SQL support here.

Querying with C#

Aside from SQL, you can also write linq queries against your 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 in a fantastically simple way. This makes importing, exporting and combining DB/Excel data trivial.

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 copied to the database (as temp tables) each time the connection is established.

Connected to DB

You can now query the 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 and you can query away. These are just the basics, though, there's a lot more interesting stuff in the rest the documentation so do take a look. And if you like videos more than text, check out the video tutorials over here.

Comments