QueryStorm

Excel Plugin adds powerful development and data processing capabilities into Microsoft Excel.

Published by QueryStorm
Distributed by ComponentSource since 2018

Prices from: $ 371.42 Version: 2.12.x Updated: Apr 12, 2024

Screenshot of QueryStorm

QueryStorm Features

Use SQL on Excel tables.
SQL support in Excel
Process data and build smart workbooks with C#/LINQ in Excel.
C# support in Excel
Query Excel tables alongside database tables in the same query.
Database Connectivity
Advanced code editor for effective C# and SQL coding.
Fully-featured IDE
Use SQL on Excel tables.

Use SQL on Excel tables.

With QueryStorm’s SQLite engine, you can work with Excel tables as if they were database tables.

Use SQL to clean, query and process live data inside Excel, without the need to import/export data.

QueryStorm

Click for more<strong>Use SQL on Excel tables.</strong><br /><br />
Process data and build smart workbooks with C#/LINQ in Excel.

Process data and build smart workbooks with C#/LINQ in Excel.

With QueryStorm’s C# support you can run LINQ queries against tables in Excel.

If you’re loading data from the outside (e.g. REST service), you can write it as a new Excel table and immediately get strongly typed access to the stored data.

Quickly prototype applications using Excel for storage, visualizations and UI, and C# for the business logic and loading data.

QueryStorm

Click for more<strong>Process data and build smart workbooks with C#/LINQ in Excel.</strong><br /><br />
Query Excel tables alongside database tables in the same query.

Query Excel tables alongside database tables in the same query.

QueryStorm supports connecting to external databases including SQL Server, PosgreSQL, MySQL, Oracle, DB2, SQLite and Access.

When connecting, you select which Excel tables will be visible to the database in the form of temp tables.

This feature enables users to more easily move live data between Excel and databases, and to query them together. It makes Excel a natural extension of the database and vice versa.

QueryStorm

Connecting to external databases
Connecting to external databases
Querying Excel tables alongside permanent database tables.
Querying Excel tables alongside permanent database tables.
Click for more

Image 1 / 2

Connecting to external databases
Querying Excel tables alongside permanent database tables.
Advanced code editor for effective C# and SQL coding.

Advanced code editor for effective C# and SQL coding.

QueryStorm’s code editor sports many of the features you might expect from a modern IDE. It offers intellisense, error squiggles, code formatting, bracket matching, function documentation tooltips, start expansion and more...

QueryStorm

Full autocomplete for SQL and C#
Full autocomplete for SQL and C#
Error hints for faulty code
Error hints for faulty code
SQL star expansion
SQL star expansion
Tooltips display function/parameter documentation
Tooltips display function/parameter documentation
Automatically formatting user code
Automatically formatting user code
Click for more

Image 1 / 5

Full autocomplete for SQL and C#
Error hints for faulty code
SQL star expansion
Tooltips display function/parameter documentation
Automatically formatting user code