QueryStorm

  1. Advanced code editor for effective C# and SQL coding.

    Fonctionnalités : 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... Full autocomplete for SQL and ...

  2. Query Excel tables alongside database tables in the same query.

    Fonctionnalités : 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 ...

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

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

    Fonctionnalités : 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 ...

  4. Use SQL on Excel tables.

    Use SQL on Excel tables.

    Fonctionnalités : 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. ...