SQL2Excel v2.1.5
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
Multi-Database Support(v2.0.0)
Unified adapters for multiple databases with flexible per-sheet and per-variable routing
- Supported: Oracle, MSSQL, MySQL, MariaDB, PostgreSQL, SQLite
- Runtime precedence: CLI --db > excel.db; sheet.db; dynamicVar.database|db
- Dynamic variables can run on their own DB adapter
- Connection test: node src/excel-cli.js list-dbs / sql2excel.exe list-dbs
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
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
- Sheet name length over 31 characters are truncated to 31 characters
- Original sheet name displayed in TOC as a separate column
CSV/TXT Per-sheet Export (v1.3.0)
CSV/TXT per-sheet export
- Routing based on output extension
- - .xlsx / .xls → Single Excel workbook (existing)
- - .csv → Per-sheet CSV files
- - Others → Per-sheet TXT typed files
- Directory naming for per-sheet export
- - Files created under
- - ex) output="d:/temp/report.csv" → d:/temp/report/
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
Filename Variables and DATE Improvements (v1.3.1)
- Enhanced output filename variables
- - Supports ${DB_NAME} in excel.output
- - Continues to support timezone form ${DATE.TZ:...}
- Lowercase date tokens supported
- - Added yyyy, yy, dd, d, hh, h, sss
- Removed automatic timestamp suffix
- - No auto _yyyymmddhhmmss;
New Non-interactive CLI Feature Added (v1.2.10)
Non-interactive CLI
- Run directly with --mode flag without menu
- Modes: validate, test, export, help
- Supported in both Node and packaged EXE
Global Timezone Support (v1.2.9)
Support for 22 timezones worldwide with flexible date/time formatting
- 22 timezones: UTC, GMT, KST, JST, CST, EST, PST, ICT, PHT, AST, etc.
- Unified variable format: ${DATE.UTC:format}, ${DATE.KST:format}
- Regional date formats (Korean, Japanese, European, etc.)
- Multi-timezone display for global reports
Enhanced Validation System
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
- UTF-8 encoding support for Windows
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
- Timezones: 22 global timezones support
- DateTime Variables: Flexible custom format
- Dynamic Variables: Real-time data extraction
- Input Validation: Whitespace trimming
Database Support
- Supported DBs: MSSQL, MySQL, MariaDB, PostgreSQL, SQLite, Oracle
- Routing: Per-workbook, per-sheet, and per-variable (dynamicVar)
- Adapter behavior: Auto adapts row limiting/functions (TOP vs LIMIT)
- Connection Test: list-dbs command (Node & EXE)
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