QueryStorm(英語版)
Microsoft Excelに強力な開発とデータ処理機能を追加するExcelプラグイン
QueryStorm 社の製品
2018 年より日本国内にてComponentSourceで販売中。
価格:¥ 78,650 (税込)〜 バージョン: 2.12.x 新機能 更新日: Mar 16, 2024
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.
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 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.
画像1 / 2
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...
画像1 / 5