SQL2Excel v1.2.7
Professional tool for converting SQL query results into advanced styled and templated multi-sheet Excel files with interactive menu system, multilingual support, and enhanced validation
Key Features
Template Style System
7 pre-defined Excel style templates for consistent design and professional report generation
- Default, Modern, Dark, Colorful, Minimal, Business, Premium styles
- Global and sheet-specific style application
- Template style customization
- Style listing via CLI
Enhanced Dynamic Variables
Extract values from database in real-time with advanced processing and key-value pairs support
- column_identified and key_value_pairs types
- Pre-execution variable processing and caching
- Debug mode for variable substitution verification
- Error handling and empty result replacement
Table of Contents
Generate independent table of contents Sheet for enhanced report management and sharing
- Sheet-specific record count display (template available)
- Sheet-specific applied SQL query display
Multi-sheet Excel Generation
Organize multiple SQL query results into separate sheets within a single Excel file for systematic reporting
- Independent query execution per sheet
- Individual sheet enable/disable settings
- Dynamic sheet names (variable support)
- Maximum record limit per query
SQL Server Database Support
Connect to SQL Server database systems and execute queries from different sources
(More database will be added in the future ...)
- SQL Server
- Connection pooling
- Transaction support
- Error handling
Standalone Executable
Generate versioned standalone .exe files for distribution without Node.js dependency
- Self-contained executable with all dependencies
- Versioned filename (sql2excel-v1.2.4.exe)
- Asset bundling (templates, styles)
- No Node.js installation required
Enhanced DateTime Variables
20+ automatic datetime variables for real-time timestamp generation in various formats
- UTC and Korean Standard Time (KST)
- Korean localized formats (2024년 10월 5일)
- Compact formats (YYYYMMDD, HHMMSS)
- ISO timestamps and Unix timestamps
Creation Timestamp
Automatically display creation timestamp on each Excel sheet for audit trails
- Korean locale formatting
- Database source information
- Consistent visual styling
- No configuration required
Multi-language Support
Automated Korean and English release package generation with localized interfaces
- Korean and English batch interfaces
- Localized documentation
- Language-specific release packages
- Automated documentation sync
Improved Batch Interface (v1.2.5)
More intuitive and user-friendly numbered file selection system
- Numbered file selection menu
- Automatic XML/JSON file detection and separation
- Enhanced input validation
- Better empty directory handling
Interactive Multilingual Menu (v1.2.6)
User-friendly interactive menu system in sql2db style with complete multilingual support
- app.js-based interactive menu system
- run.bat (English), 실행하기.bat (Korean) launcher scripts
- Language selection via command-line argument (--lang=en/kr)
- Fully localized menus, messages, and errors
Enhanced Validation System (v1.2.6)
Detailed sheet name validation and database information output
- Full sheet list display with individual validation results
- Detailed database info output (server, DB name, user, permissions)
- Auto-correction for sheet names (during execution)
- Detailed error reports during file validation
Optimized Validation & Encoding (v1.2.7)
Improved query file validation and character encoding fixes
- Shows only databases used in query files during validation
- Removed unnecessary filename character restrictions
- Fixed character corruption in release batch files
- UTF-8 encoding support for Windows
Internationalized Sample Files (v1.2.7)
All query sample files converted to English for global accessibility
- English-only query sample files
- Standardized column names and sheet names
- Improved cross-platform compatibility
- Better readability for international users
Technical Specifications
Platform & Runtime
- Platform: Node.js 16.0+
- Excel Library: ExcelJS
- OS Support: Windows, Linux, macOS
- Architecture: Cross-platform
Excel Generation
- Template Styles: 7 pre-defined styles
- Multi-sheet Support: Unlimited sheets per file
- Creation Timestamp: Automatic timestamp display
- SQL Formatting: Preserve original query formatting
Configuration & Variables
- Format: XML, JSON
- Validation: Built-in configuration validation
- DateTime Variables: 20+ automatic functions
- Dynamic Variables: Real-time data extraction
- Input Validation: Whitespace trimming
Database Support
- SQL Server: Full support with encryption
- Connection Pooling:
- Transaction Support
- Exception Handling
Deployment & Distribution
- Standalone Executable: No Node.js required
- Multi-language Packages: Korean & English
- Release Automation: Automated build process
- Version Management: Dynamic versioning
Use Cases
Business Reporting
Generate comprehensive business reports with multiple data sources and professional styling
- Sales and revenue reports with templates
- Customer analytics with dynamic variables
- Performance dashboards with multi-sheets
Data Analysis
Transform raw database data into structured Excel files for analysis with enhanced formatting
- Statistical analysis with aggregation
- Trend identification with charts
- Data visualization with custom styles
Documentation & Reference
Create documentation and reference materials from database queries with table of contents
- Data dictionaries with TOC
- Reference tables with validation
- Audit reports with file validation
Automated Reporting
Automate regular report generation with scheduled execution and dynamic content
- Daily/weekly reports with variables
- Automated distribution with CLI
- Template-based generation with styles