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...

Dernières nouvelles

QueryStorm 2.5.7923.20438
QueryStorm 2.5.7923.20438
Prend en charge la configuration SSL dans les chaînes de connexion Postgres.
QueryStorm 2.5
QueryStorm 2.5
Met à jour C# de la version 7.1 vers la version 9, et met à niveau SQLite vers la dernière version (inclut des fonctionnalités liées aux fenêtres).
QueryStorm 2.4
QueryStorm 2.4
Prend en charge les documents approuvés et améliore la prise en charge des menus contextuels.
QueryStorm 2.3.7822.26514
QueryStorm 2.3.7822.26514
Le préprocesseur SQL comporte désormais des fonctions asynchrones et des gestionnaires d’événements.
QueryStorm 2.2.7730.34357
QueryStorm 2.2.7730.34357
Les extensions QueryStorm peuvent désormais définir des raccourcis et permettre aux utilisateurs de les configurer.
QueryStorm 2.0
QueryStorm 2.0
Ajoute un nouveau système de projets, apporte des modifications à l’automatisation, et prend en charge NuGet et VB.NET.

Prix à partir de : $ 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...

Vous avez une question ?

Discutez en direct avec l'un de nos spécialiste des licences QueryStorm .

Fonctionnalités clés

QueryStorm
En tant que distributeurs officiels et autorisés, ComponentSource vous fournit directement des licences légitimes à partir de QueryStorm.
Product Type
  • Add-In