Decorate SQL queries with a simple preprocessor directive to expose them to Excel as functions. Creating Excel functions that load database data is about as easy as writing the SQL.
Write functions in C# and VB.NET right inside Excel. Compile the function and use it in Excel right away.
Your .NET functions can return values that change over time. A typical use case for this is displaying stock prices.
Share your functions
Building functions for your own use is great, but when you share them, many more people can benefit. Publish your functions to a network location or to Azure to share them with colleagues and clients.
Get NuGet packages
You don't need to write your functions from scratch. Make use of the thousands of powerful libraries available in the .NET ecosystem using QueryStorm's NuGet support.