sql_export_excel

Purpose

This module enables exporting data from SQL queries to Excel files, supporting both new file creation and data insertion into existing Excel templates.

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.