Excel export from sql using python

import pandas as pd
import xlsxwriter
import pyodbc


conn = pyodbc.connect('Driver={SQL Server}; Server=ServerIP; uid=UID; pwd=Password; Trusted_Connection=No;')
 with pd.ExcelWriter("Output.xlsx", engine="xlsxwriter", options = {'strings_to_numbers': True, 'strings_to_formulas': False}) as writer:
        try:
            df = pd.read_sql("Select * from Orders", conn)
            df.to_excel(writer, sheet_name = "Sheet1", header = True, index = False)
            print("File saved successfully!")
        except:
            print("There is an error")

Source: stackoverflow.com

Similar codes

0 vote199 views1 answer
Alter owner in PostgreSQL
SQL
0 vote209 views1 answer
Oracle list datafiles
SQL
0 vote193 views1 answer
Char varchar nvarchar sql
SQL
1 vote207 views1 answer
How to update date add hours in postgresql
SQL
0 vote208 views2 answers
Sql query inner join 3 tables
SQL
1 vote210 views1 answer
Oracle sql average
SQL
0 vote235 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote196 views1 answer
Difference between 2 query results sql server
SQL
3 votes204 views2 answers
Postgres alter table owner
SQL
0 vote205 views1 answer
Snap craft
SQL