6.1 -learning python

import openpyxl
import pyodbc
import base64
#设置数据库连接信息
server_name=''
database_name=''
username=''
password=''
driver='ODBC Driver 17 for SQL Server'



#设置Excel文件路径和工作表名称
excel_file='New Microsoft Excel Worksheet.xlsx'
sheet_name="Sheet1"
sql_query='''select * from sys.sql_logins
where sid ='''
conn_str=f"DRIVER={driver};SERVER={server_name};DATABASE={database_name};UID={username};PWD={password}"

conn = pyodbc.connect(conn_str)
cursor=conn.cursor()


column_data=[]


wb=openpyxl.load_workbook(filename=excel_file)
ws=wb[sheet_name]
for cell in ws['D']:
        column_data.append(cell.value)

#遍历数据
for i in range(2, len(column_data) + 1 ): 
        data=column_data[i-2]
        cursor.execute(sql_query+data)
        
        result= cursor.fetchone()
        if result is None : continue
        str1=''.join(str(i) for i in result[0])
        ws.cell(row=i, column=2,value=str1)
        
cursor.close()
conn.close()
wb.save(excel_file)