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.
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.
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.
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:
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.
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.
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.