Reading SQL scripts from excel file and run it using python

[saravanatn]

Hi All,

I placed my SQL scripts in excel file and my python code needs to read the SQL code from excel and then run the SQL code from SQL Server using Python . If the fetch row is greater than zero then it is 'Failed' else 'Passed'. This failed or Passed results needs to be writes into Excel file as output.
What I tried do far . I am able to run the SQL scripts directly

import pyodbc 
conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=ServerName;'
                      'Database=DatabaseName;'
                      'Trusted_Connection=yes;')

cursor = conn.cursor()
cursor.execute('SELECT * FROM  [DUMMY]')
title = [i[0] for i in cursor.description]
print (title)
for row in cursor:
    print(row)

I am able to read the excel files separately . When I merge both the code I am getting error from SQL code part

import xlrd
file_location= "pathname"
workbook =xlrd.open_workbook(file_location)
sheet =workbook.sheet_by_index(0)
sheet.cell_value(0,0)