QueryStormQueryStorm
Build AutomationWhat is QueryStorm?
A fully featured SQL and C# IDE in Excel. It turns Excel into a powerful developer tool for processing tabular data and building interactive workbook applications.
QueryStorm is a tool in the Build Automation category of a tech stack.
Key Features
Full SQL support in Excel - Use SQL to clean, query and modify data in Excel as if the data was in a database.
Get the best of both worlds: the processing power of SQL and the flexibility and visualization capabilities of ExcelFull C# support - Run LINQ queries against Excel tablesautomate Excel using C# (instead of VBA)load data from almost anywhere using any .NET library.
You can even write C# functions and call them directly from SQL (with autocomplete too)Two-way database connectivity - Connecting to an external database opens a two-way connection between Excel and the database, making it easy to move data in either direction. QueryStorm supports SQL Server, Postgres, Redshift, MySql, Oracle, SQLite, Access, and ODBC.
QueryStorm Pros & Cons
Pros of QueryStorm
No pros listed yet.
Cons of QueryStorm
No cons listed yet.
QueryStorm Alternatives & Comparisons
What are some alternatives to QueryStorm?
npm
npm is the command-line interface to the npm ecosystem. It is battle-tested, surprisingly flexible, and used by hundreds of thousands of JavaScript developers every day.
Visual Studio
Visual Studio is a suite of component-based software development tools and other technologies for building powerful, high-performance applications.
IntelliJ IDEA
Out of the box, IntelliJ IDEA provides a comprehensive feature set including tools and integrations with the most important modern technologies and frameworks for enterprise and web development with Java, Scala, Groovy and other languages.
Webpack
A bundler for javascript and friends. Packs many modules into a few bundled assets. Code Splitting allows to load parts for the application on demand. Through "loaders" modules can be CommonJs, AMD, ES6 modules, CSS, Images, JSON, Coffeescript, LESS, ... and your custom stuff.
