QueryStorm
Excel Plugin은 Microsoft Excel에 강력한 개발 및 데이터 처리 기능을 추가합니다.
QueryStorm사에서 공개
2018년 부터 ComponentSource에서 판매중
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