Skip to content

Instantly share code, notes, and snippets.

@KamilKoso
KamilKoso / ExcelToInsert.py
Created March 4, 2025 09:11
Excel to insert statements
import pandas as pd
def generate_insert_statements(excel_file, table_name):
# Load the Excel file
df = pd.read_excel(excel_file)
# Get column names
columns = df.columns.tolist()
# Generate VALUES part