Create Excel file from SQL query using Python
This will create a file called “emp.xls” with a nicely formatted spreadsheet based on the query specified. The header row is based on the column names, and is frozen. The column widths are set according to the max width of the data.
import cx_Oracle from table2Excel import write_cursor_to_excel orcl = cx_Oracle.connect('scott/tiger') curs = orcl.cursor() curs.execute(""" SELECT e.ename "Employee", e.job "Job", e.hiredate "Hire Date", e.sal "Salary", e.comm "Commission", d.dname "Department", (SELECT ename FROM emp WHERE emp.empno = e.mgr) "Manager" FROM emp e, dept d WHERE e.deptno = d.deptno """) write_cursor_to_excel(curs, 'emp.xls', 'Employees')
You can get the source for table2Excel from here [table2Excel.py.txt]. Feel free to adapt it to your needs.