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 several times throughout this documentation.
Excel tables are quite similar to database tables. They have names, delineate data from surrounding content, allow basic sorting and filtering and enforce consistency in columns (column names are unique, cells in a column share the same formula). As such, they are the ideal structure for QueryStorm to work with.
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.
You can read more about the SQL support here.
Querying with C#¶
Aside from SQL, you can also query data via C#. Excel tables show up as strongly typed collections that you can query and modify. Click the Connect (C#) button in the ribbon to open the IDE and start an interactive C# session.
You can read more about QueryStorm's C# support here.
Connecting to external databases¶
Moving data between Excel and databases is usually quite tedious. QueryStorm makes combining database and spreadsheet data much easier allowing you to run queries that combine data from Excel tables with data from permanent database tables.
To connect to an external database, click Connect custom. A dialog will appear allowing you to choose (or define) a database connection:
While defining the connection, you can select which Excel tables will be visible to the database engine. 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.