QueryStorm

The product is an Excel extension that lets users run SQL and C#/VB.NET code inside spreadsheets to query tables, process data, connect databases, automate workbooks and create custom functions. It is for software engineers, data professionals and business users in organizations that rely on Excel for data work. It is delivered as an add-in with an integrated IDE, distributable runtime and extensions gallery that brings programming and database connectivity directly into Excel.

Key features

• Query Excel tables with SQL
• Run C# scripts and LINQ queries
• Connect databases to Excel
• Automate workbooks with .NET or SQL
• Create custom Excel functions
• Intelligent IDE with code completion
• Distributable runtime for sharing
• Extensions gallery
• NuGet support
• External database connectivity