GitHub - Ardrake/Sql2Excel: Python script to export SQL Query result in an excel spreadsheet

Ardrake / Sql2Excel Public

Notifications You must be signed in to change notification settings
Fork 1
Star 0

Python script to export SQL Query result in an excel spreadsheet

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
REQUETE.ini		REQUETE.ini
Sql2Excel.py		Sql2Excel.py
readme.txt		readme.txt

Repository files navigation

Sql2Excel - Python 

Dumps Sql query results in an excel spreadsheet

Uses an ini file passed as an argument to the script for connexion info and query

by default uses the REQUETE.INI file.

______________________________________________________________________________________

Requires : pyodbc, pandas and ConfigParser
______________________________________________________________________________________

Ini file example

[SQL2EXCEL]
temp_folder = C:/Temp/     <---  Temp folder 
nom_export = fichier       <---  Spreadsheet filename
nom_feuille = page 1       <---  Spreadsheet sheet/page name

requete_sql = 	SELECT top 50 *        
		FROM CLIENT                    <--- Sql Query
		WHERE CLADR4 = 'Québec'
		
[INFO_CNXN]
CNXN_SERVER = SERVER      <--- Server address
CNXN_DATABASE = DATABASE  <--- Database name
USER_ID = USER            <--- User
USER_PSWD = PASS		  <--- Password



Author : André Cooke
Couriel : [email protected]