QueryStorm

QueryStorm is an add-in for Microsoft Excel for tech savvy professionals who work with spreadsheets. It’s an IDE and runtime that allows using SQL and C# inside Excel making spreadsheets much more useful and accessible to tech users. For tech users who spend any considerable time in Excel, lack of proper support for tech skills tends to be a source of frustration. The purpose of QueryStorm is to greatly reduce this problem by adding easy and convenient support for SQL and C# into Excel, as well as better database connectivity. QueryStorm makes moving data between Excel and databases much easier. As soon as you connect, Excel tables are visible to the database (as temp tables).

I had a large migration from HR to clean and turn into one Excel report. The data was a real mess, it was all in different layouts and some of it was in PDF files. Months of work ended up taking me a week, using QueryStorm to write SQL queries to transform the data.

Pedrag Petrovic, Head of IT, Construction

QueryStorm Features

  • Speaks your language - Use SQL, C#, and VB.NET right inside Excel to process data, build custom functions and automate workbooks.
  • Intelligent IDE - Code completion, syntax highlighting, code fixes, and much more. With QueryStorm's IDE, writing code is a breeze.
  • Distributable runtime - Share your functions and automated workbooks with clients and colleagues. All they need to use them is the QueryStorm Runtime.
  • Query data in Excel - QueryStorm lets you use SQL and C# in Excel...

最新新闻

QueryStorm 2.10.505.0
QueryStorm 2.10.505.0
August 15, 2023新版本
添加状态栏服务以显示同步操作的状态。
QueryStorm 2.10.502.0
QueryStorm 2.10.502.0
July 24, 2023新版本
将文字环绕添加到“概要”字段。
QueryStorm 2.10.501.0
QueryStorm 2.10.501.0
July 14, 2023新版本
添加改进安装的新运行时 VSTO 外接程序。
QueryStorm 2.9.8525.20169
QueryStorm 2.9.8525.20169
May 5, 2023新版本
添加用于限制和 API 密钥管理的 HTTP 请求基础结构。
QueryStorm 2.8.8503.17156
QueryStorm 2.8.8503.17156
April 13, 2023新版本
C# 脚本现在可以使用 #load 指令引用其它 C# 脚本。
QueryStorm 2.7.8487.32462
QueryStorm 2.7.8487.32462
March 30, 2023新版本
新的 GPT 驱动的 copilot 可让您根据 SQL 注释生成 SQL 代码。

价格从: $ 371.42

Prices are per seat。 All licenses are perpetual and include 1 year of support and upgrades。 SQL Professional: SQL in Excel, Advanced IDE features, External database connectivity, Workbook automation...

有任何疑问吗?

透过Live Chat与我们的QueryStorm 专家联络!

功能亮点

QueryStorm
作为官方和授权的代理商,ComponentSource 为你提供QueryStorm的正版授权。
Product Type
  • Add-In