This document is a 2-minute introduction to help you quickly get started with QueryStorm.
QueryStorm works with Excel tables (not sheets). This is an important distinction, so I mention it a few more times throughout this documentation.
!!! Note Press Ctr+T on a cell or a block of cells to convert it to a table.
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.
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.
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.
Read more about QueryStorm's C# support here.
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:
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.
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.
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.