sql_export_excel
This module enables exporting data from SQL queries to Excel files, supporting both new file creation and data insertion into existing Excel templates.
Key Features
- sql.export: Adds Excel as a selectable file format for SQL exports.
- sql.export: Provides an option to include or exclude column headers in Excel exports.
- sql.export: Allows attaching an existing Excel file as a template for data insertion.
- sql.export: Enables specifying the sheet position in the template where data should be inserted.
- sql.export: Supports setting the starting row position for data insertion in the template.
- sql.export: Allows defining the starting column position for data insertion in the template.
- sql.export: Validates that sheet, row, and column positions are positive integers.
- sql.export: Handles complex data types like dictionaries by converting them to strings for Excel compatibility.