QueryStorm

Excel Plugin은 Microsoft Excel에 강력한 개발 및 데이터 처리 기능을 추가합니다.

QueryStorm사에서 공개
2018년 부터 ComponentSource에서 판매중

가격: US$ 371.42 버젼: 2.12.x 업데이스 날짜: Apr 12, 2024

QueryStorm 스크린샷

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.
Process data and build smart workbooks with C#/LINQ in Excel.
Use SQL on Excel tables.
Use SQL on Excel tables.
Automatically formatting user code
Automatically formatting user code
Tooltips display function/parameter documentation
Tooltips display function/parameter documentation
SQL star expansion
SQL star expansion
Error hints for faulty code
Error hints for faulty code
Full autocomplete for SQL and C#
Full autocomplete for SQL and C#
Querying Excel tables alongside permanent database tables.
Querying Excel tables alongside permanent database tables.
Connecting to external databases
Connecting to external databases
클릭하여 상세내용 보기

이미지 1/10

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

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의 상세 정보

최신 뉴스

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신규 버전
'Summary' 필드에 텍스트 줄 바꿈을 추가합니다.
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 기반 코파일럿을 사용하면 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...
라이선스의 상세 내용

궁금한 점이 있으세요?

QueryStorm 사 제품 라이선스 담당자와 라이브 채팅

기능 별 하이라이트

Use SQL on Excel tables.Process data and build smart workbooks with C#/LINQ in Excel.Query Excel tables alongside database tables in the same query.Advanced code editor for effective C# and SQL coding.
기능 상세 내용
QueryStorm
QueryStorm사 제품의 배포자로서 공식 권한을 소유한 ComponentSource는 합법적인 라이선스를 고객님께 직접 제공합니다.
QueryStorm의 상세 정보
Product Type
  • Add-In
호환성 상세 내용