Breaking News: Grepper is joining You.com. Read the official announcement!

How to Export Sql Server Result to Excel in Python

Mappy Show answered on April 20, 2021 Popularity 7/10 Helpfulness 10/10

answer How to Export Sql Server Result to Excel in Python

related excel export from sql using python

How to Export Sql Server Result to Excel in Python

Comment

import pyodbc
import pandas as pd

cnxn = pyodbc.connect(< db details here >)
script = """
SELECT * FROM my_table
"""

df = pd.read_sql_query(script, cnxn)

Popularity 7/10 Helpfulness 10/10 Language python

Source: stackoverflow.com

Tags: excel export python sql-server

Link to this answer
Share Copy Link

Contributed on May 08 2022

Mappy Show

0 Answers Avg Quality 2/10

Closely Related Answers

excel export from sql using python

Comment

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")

Popularity 9/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: excel export exp

Link to this answer
Share Copy Link