QueryStorm の主な機能

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.

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.

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.

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