QueryStorm
Excel 外掛程式將強大的開發和資料處理功能添加到 Microsoft Excel 中。
由以下開發商製作:QueryStorm
ComponentSource 開始代理銷售的日期:2018年
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).
QueryStorm
Process data and build smart workbooks with C#/LINQ in Excel.
Use SQL on Excel tables.
Automatically formatting user code
Tooltips display function/parameter documentation
SQL star expansion
Error hints for faulty code
Full autocomplete for SQL and C#
Querying Excel tables alongside permanent database tables.
Connecting to external databases
圖像1/10
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
August 15, 2023新版本
添加狀態列服務以顯示同步操作的狀態。
QueryStorm 2.10.502.0
July 24, 2023新版本
將文字環繞添加到「概要」欄位。
QueryStorm 2.10.501.0
July 14, 2023新版本
添加改進安裝的新運行時 VSTO 外接程式。
QueryStorm 2.9.8525.20169
May 5, 2023新版本
添加用於限制和 API 金鑰管理的 HTTP 請求基礎結構。
QueryStorm 2.8.8503.17156
April 13, 2023新版本
C# 文稿現在可以使用 #load 指令引用其它 C# 文稿。
QueryStorm 2.7.8487.32462
March 30, 2023新版本
新的 GPT 驅動的 copilot 可讓您根據 SQL 注釋生成 SQL 代碼。價格從： US$ 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 專家即時聊天詢問。
功能特點
