Export SQL query results to Microsoft Excel
- Create MS Excel files (.xlsx) based on SQL queries stored in text files in specified folder
- Excel files are compatible with MS Office 2007, 2010 and 2013 and Microsoft 365
- Tabular data shape - files can be read by Ole.Db (e.g. Provider=Microsoft.ACE.OLEDB.12.0)
- Columns are formatted based on data types returned from sql query (numbers, integers, text, datetime)
- String values and dates are saved as shared strings in Excel (limits file size && speeds up opening large files)
- Output files are Mac compatible
- SQL queries can be stored in .sql files, the tool runs against a folder path containing multiple .sql files
- Input files can contain comments (both block and single line comments)
- SQL queries can be run against the following databases: Microsoft SQL Server, PostgreSQL, ODBC
- Logging (various levels, console and log file with a path specified by user) - the library is using LibLog and SeriLog with Console and File sinks
- Queries can be executed in Parallel (use Maxdop parameter)
- Excel generation using: Fast streaming adapter using OpenXmlWriter (SAX) or standard OpenXml (DOM/ODC) (slower)